Αποτελέσματα Αναζήτησης
The MySQL SHOW GRANTS statement returns all privileges and roles granted to an account user or role. Here’s the basic syntax of the SHOW GRANTS statement: SHOW GRANTS [ FOR { user | role } [ USING role [, role ] ...]]
24 Σεπ 2008 · You may need to Show Grants Statement. SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be executed to duplicate the privilege assignments.
SHOW GRANTS requires the SELECT privilege for the mysql system schema, except to display privileges and roles for the current user. To name the account or role for SHOW GRANTS, use the same format as for the GRANT statement (for example, 'jeffrey'@'localhost'):
To enable the user account to work with database objects, you need to grant it privileges. You use the GRANT statement to assign one or more privileges to the user account. Here’s the basic syntax of the GRANT statement: GRANT privilege [,privilege],.. ON privilege_level.
MySQL table grants are stored in the TABLE_PRIVILEGES table in the information_schema database in MySQL. To be able to see the grants defined in the table, the user needs to have permissions to view this table.
The GRANT statement enables system administrators to grant privileges and roles, which can be granted to user accounts and roles. These syntax restrictions apply: GRANT cannot mix granting both privileges and roles in the same statement. A given GRANT statement must grant either privileges or roles.
SHOW GRANTS requires the SELECT privilege for the mysql system schema, except to display privileges and roles for the current user. To name the account or role for SHOW. GRANTS, use the same format as for the GRANT statement (for example, 'jeffrey'@'localhost'): mysql> SHOW GRANTS FOR 'jeffrey'@'localhost';
