Αποτελέσματα Αναζήτησης
21 Μαρ 2012 · Figure out how to do this for current user without DBA privileges. Probably involves USER_SYS_PRIVS (directly granted system privileges), USER_TAB_PRIVS (directly granted object privs) USER_ROLE_PRIVS (user's directly granted roles), ROLE_ROLE_PRIVS (for getting inherited roles), ROLE_SYS_PRIVS (system privs through roles) and ROLE_TAB_PRIVS ...
1 Οκτ 2021 · MySQL does not have a direct command to show all users' privileges. For a quick overview, you can query the information_schema.user_privileges table: SELECT * FROM information_schema.user_privileges; However, this table only shows global user privileges without database-specific grants.
28 Αυγ 2012 · This Linux shell fragment loops over all MySQL users and does a SHOW GRANTS for each: mysql --silent --skip-column-names --execute "select concat('\'',User,'\'@\'',Host,'\'') as User from mysql.user" | sort | \. while read u.
The GRANT statement assigns privileges and roles to MySQL user accounts and roles.
This statement displays the privileges and roles that are assigned to a MySQL user account or role, in the form of GRANT statements that must be executed to duplicate the privilege and role assignments. Note. To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER statement.
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();
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 ] ...]]
