Method get

Статья создана

Yandex Cloud

улучшена

amatol

HTTP request
Path parameters
Response

Retrieves information about the specified user.

HTTP request

GET https://mdb.api.cloud.yandex.net/managed-mysql/v1/clusters/{clusterId}/users/{userName}

Path parameters

Parameter	Description
clusterId	Required. ID of the cluster the user belongs to. To get this ID, make a list request. The maximum string length in characters is 50.
userName	Required. Name of the user to return information about. To get this name, make a list request. The maximum string length in characters is 63. Value must match the regular expression `[a-zA-Z0-9_]*`.

Response

HTTP Code: 200 - OK

{
  "name": "string",
  "clusterId": "string",
  "permissions": [
    {
      "databaseName": "string",
      "roles": [
        "string"
      ]
    }
  ],
  "globalPermissions": [
    "string"
  ],
  "connectionLimits": {
    "maxQuestionsPerHour": "integer",
    "maxUpdatesPerHour": "integer",
    "maxConnectionsPerHour": "integer",
    "maxUserConnections": "integer"
  },
  "authenticationPlugin": "string"
}

An object that represents MySQL user.

See the documentation for details.

Field	Description
name	string Name of the user.
clusterId	string ID of the cluster the user belongs to.
permissions[]	object Set of permissions granted to the user.
permissions[]. databaseName	string Name of the database that the permission grants access to.
permissions[]. roles[]	string ALL_PRIVILEGES: All privileges that can be made available to the user. ALTER: Altering tables. ALTER_ROUTINE: Altering stored routines 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 MySQL documentation for details. 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. REFERENCES: Creation of a foreign key constraint for the parent table.
globalPermissions[]	string REPLICATION_CLIENT: Enables use of the `SHOW MASTER STATUS`, `SHOW SLAVE STATUS`, and `SHOW BINARY LOGS` statements. REPLICATION_SLAVE: Enables the account to request updates that have been made to databases on the master server, using the `SHOW SLAVE HOSTS`, `SHOW RELAYLOG EVENTS` and `SHOW BINLOG EVENTS` statements. PROCESS: Enables display of information about the the statements currently being performed by sessions (the set of threads executing within the server). The privilege enables use of `SHOW PROCESSLIST` or `mysqladmin` processlist to see threads belonging to other users. You can always see your own threads. The `PROCESS` privilege also enables use of `SHOW ENGINE`.
connectionLimits	object Set of user connection limits.
connectionLimits. maxQuestionsPerHour	integer (int64) The maximum permitted number of user questions per hour. The minimum value is 0.
connectionLimits. maxUpdatesPerHour	integer (int64) The maximum permitted number of user updates per hour. The minimum value is 0.
connectionLimits. maxConnectionsPerHour	integer (int64) The maximum permitted number of simultaneous client connections per hour. The minimum value is 0.
connectionLimits. maxUserConnections	integer (int64) The maximum number of simultaneous connections permitted to any given MySQL user account. The minimum value is 0.
authenticationPlugin	string User authentication plugin. MYSQL_NATIVE_PASSWORD: Use Native Pluggable Authentication. CACHING_SHA2_PASSWORD: Use Caching SHA-2 Pluggable Authentication. SHA256_PASSWORD: Use SHA-256 Pluggable Authentication.

Method get

HTTP request

Path parameters

Response

Была ли статья полезна?