Αποτελέσματα Αναζήτησης
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 · MySQL's SHOW GRANTS shows the permissions of the current user. Is there a way to log in as root and show the permissions of all users?
All system privileges and schema object privileges that permit a user to perform a DDL operation are usable when received through a role. Examples: System Privileges: the CREATE TABLE, CREATE VIEW and CREATE PROCEDURE privileges. Schema Object Privileges: the ALTER and INDEX privileges for a table.
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.
2 Αυγ 2010 · SHOW GRANTS displays privilege and role assignments for user accounts and roles. SET DEFAULT ROLE specifies which account roles are active by default. SET ROLE changes the active roles within the current session. The CURRENT_ROLE() function displays the active roles within the current session.
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();
