Αποτελέσματα Αναζήτησης
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 might want to check out mk-show-grants from Maatkit, which will output the current set of grants for all users in a canonical form, making version control or replication more straightforward.
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';
6 Ιαν 2014 · 1 Answer. Sorted by: 2. These informations are stored in the Information_schema database, in a table named TABLE_PRIVILEGES. Run a SQL like this : USE INFORMATION_SCHEMA; SELECT * FROM `TABLE_PRIVILEGES` WHERE TABLE_NAME="myTable"; Or navigate into that table using phpmyadmin. Edit :
28 Αυγ 2012 · Use common_schema's sql_show_grants view. For example, you can query: SELECT sql_grants FROM common_schema.sql_show_grants; Or you can query for particular users, for example: SELECT sql_grants FROM common_schema.sql_show_grants WHERE user='app'; To install common_schema, follow the instructions here. Disclaimer: I am author of this tool.
The world's most popular open source database Contact MySQL | Login | Register. MySQL.com; Downloads; Documentation; Developer Zone; Developer Zone Downloads MySQL.com. Documentation ... MySQL 5.7 Reference Manual. Preface and Legal Notices. General Information. Installing and Upgrading MySQL. Tutorial. MySQL Programs. MySQL Server Administration.
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';
