Αποτελέσματα Αναζήτησης
21 Μαρ 2012 · select * from user_sys_privs; select * from user_tab_privs; select * from user_role_privs; DBAs and other power users can find the privileges granted to other users with the DBA_ versions of these same views.
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.
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.
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.
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. Note. To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER statement. See Section 13.7.5.12, “SHOW CREATE USER Statement” .
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 ] ...]]
