User

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

JSON Representation
Methods

A set of methods for managing MySQL users.

JSON Representation

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

Field	Description
name	string Name of the MySQL user.
clusterId	string ID of the MySQL 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 (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. 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 threads executing within the server (that is, information about the statements being executed by sessions). The privilege enables use of SHOW PROCESSLIST or mysqladmin processlist to see threads belonging to other accounts; 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.

Methods

Method	Description
create	Creates a MySQL user in the specified cluster.
delete	Deletes the specified MySQL user.
get	Returns the specified MySQL user.
grantPermission	Grants a permission to the specified MySQL user.
list	Retrieves a list of MySQL users in the specified cluster.
revokePermission	Revokes a permission from the specified MySQL user.
update	Modifies the specified MySQL user.

User

JSON Representation

Methods

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