29 lines
2.4 KiB
Plaintext
29 lines
2.4 KiB
Plaintext
show grants;
|
|
Grants for root@localhost
|
|
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION
|
|
GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION
|
|
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION
|
|
create user 'pfs_user_5'@localhost;
|
|
grant usage on *.* to 'pfs_user_5'@localhost with GRANT OPTION;
|
|
grant SELECT(thread_id, event_id) on performance_schema.events_waits_current
|
|
to 'pfs_user_5'@localhost;
|
|
grant UPDATE(enabled) on performance_schema.setup_instruments
|
|
to 'pfs_user_5'@localhost;
|
|
flush privileges;
|
|
select thread_id from performance_schema.events_waits_current;
|
|
select thread_id, event_id from performance_schema.events_waits_current;
|
|
update performance_schema.setup_instruments set enabled='YES';
|
|
select event_name from performance_schema.events_waits_current;
|
|
ERROR 42000: SELECT command denied to user 'pfs_user_5'@'localhost' for column 'event_name' in table 'events_waits_current'
|
|
select thread_id, event_id, event_name
|
|
from performance_schema.events_waits_current;
|
|
ERROR 42000: SELECT command denied to user 'pfs_user_5'@'localhost' for column 'event_name' in table 'events_waits_current'
|
|
update performance_schema.setup_instruments set name='illegal';
|
|
ERROR 42000: UPDATE command denied to user 'pfs_user_5'@'localhost' for column 'NAME' in table 'setup_instruments'
|
|
update performance_schema.setup_instruments set timed='NO';
|
|
ERROR 42000: UPDATE command denied to user 'pfs_user_5'@'localhost' for column 'TIMED' in table 'setup_instruments'
|
|
REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'pfs_user_5'@localhost;
|
|
DROP USER 'pfs_user_5'@localhost;
|
|
flush privileges;
|
|
UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
|