Get

Returns the specified MySQL user.

To get the list of available MySQL users, make a List request.

TypeScript

import { cloudApi, serviceClients, Session } from "@yandex-cloud/nodejs-sdk";

const GetUserRequest = cloudApi.mdb.clickhouse_user_service.GetUserRequest;

(async () => {
  const authToken = process.env["YC_OAUTH_TOKEN"];
  const session = new Session({ oauthToken: authToken });
  const client = session.client(serviceClients.UserServiceClient);

  const result = await client.get(
    GetUserRequest.fromPartial({
      clusterId: "clusterId",
      userName: "userName",
    })
  );
  console.log(result);
})();

Python

import os
import grpc
import yandexcloud

from yandex.cloud.mdb.clickhouse.v1.user_service_pb2 import GetUserRequest
from yandex.cloud.mdb.clickhouse.v1.user_service_pb2_grpc import UserServiceStub

token = os.getenv("YC_OAUTH_TOKEN")

sdk = yandexcloud.SDK(token=token)

service = sdk.client(UserServiceStub)
response = service.Get(GetUserRequest(cluster_id="clusterId", user_name="userName"))
print(response)

GetUserRequest

clusterId : string

ID of the MySQL cluster.

userName : string

Name of the user.

User

A MySQL user. For more information, see the documentation.

name : string

Name of the MySQL user.

clusterId : string

ID of the MySQL cluster the user belongs to.

permissions : Permission

Set of permissions granted to the user.

Permission

Privilege

• PRIVILEGE_UNSPECIFIED

• ALL_PRIVILEGES

  All privileges that can be made available to the user.

• ALTER

  Altering tables.

• ALTER_ROUTINE

  Altering stored routines (stored procedures and functions).

• CREATE

  Creating tables or indexes.

• CREATE_ROUTINE

  Creating stored routines.

• CREATE_TEMPORARY_TABLES

  Creating temporary tables.

• CREATE_VIEW

  Creating views.

• DELETE

  Deleting tables.

• DROP

  Removing tables or views.

• EVENT

  Creating, altering, dropping, or displaying events for the Event Scheduler.

• EXECUTE

  Executing stored routines.

• INDEX

  Creating and removing indexes.

• INSERT

  Inserting rows into the database.

• LOCK_TABLES

  Using LOCK TABLES statement for tables available with SELECT privilege.

• SELECT

  Selecting rows from tables. Some SELECT statements can be allowed without the SELECT privilege. All statements that read column values require the SELECT privilege. See details in MySQL documentation.

• SHOW_VIEW

  Using the SHOW CREATE VIEW statement. Also needed for views used with EXPLAIN.

• TRIGGER

  Creating, removing, executing, or displaying triggers for a table.

• UPDATE

  Updating rows in the database.

databaseName : string

Name of the database that the permission grants access to.

roles : Privilege

Roles granted to the user within the database.

---