Αποτελέσματα Αναζήτησης
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 · To display the privileges granted to the current user (the account you are using to connect to the server), you can use any of the following statements: SHOW GRANTS; SHOW GRANTS FOR CURRENT_USER; SHOW GRANTS FOR CURRENT_USER(); note: SHOW GRANTS requires the SELECT privilege for the mysql system database, except to display privileges for the ...
With the optional USING clause, SHOW GRANTS enables you to examine the privileges associated with roles for the user. Each role named in the USING clause must be granted to the user. Suppose that user u1 is assigned roles r1 and r2, as follows: CREATE ROLE 'r1', 'r2'; GRANT SELECT ON db1.*. TO 'r1';
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.
The MySQL SHOW GRANTS statement is used to display/ retrieve the privileges and roles assigned to a role or an account. To execute this statement, you need SELECT privilege. Syntax. Following is the syntax of the MySQL SHOW GRANTS Statement −. SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] Example
For the global, database, table, and routine levels, GRANT ALL assigns only the privileges that exist at the level you are granting. For example, GRANT ALL ON db_name.* is a database-level statement, so it does not grant any global-only privileges such as FILE.
MySQL SHOW GRANTS Examples. There are some examples for the usage of MySQL SHOW GRANTS statements here. Show the privileges granted to a specified user. This example demonstrates the complete steps to create a user, grant privileges, and view privileges. Create a new database using CREATE DATABASE, named sqlizdb: CREATE DATABASE sqlizdb;
