特権を表示

このステートメントは、TiDB で割り当て可能な権限のリストを示します。これは静的なリストであり、現在のユーザーの権限を反映しません。

あらすじ

表示手順:

ShowStmt

mysql> show privileges; +---------------------------------+---------------------------------------+-------------------------------------------------------+ | Privilege | Context | Comment | +---------------------------------+---------------------------------------+-------------------------------------------------------+ | Alter | Tables | To alter the table | | Alter routine | Functions,Procedures | To alter or drop stored functions/procedures | | Config | Server Admin | To use SHOW CONFIG and SET CONFIG statements | | Create | Databases,Tables,Indexes | To create new databases and tables | | Create routine | Databases | To use CREATE FUNCTION/PROCEDURE | | Create role | Server Admin | To create new roles | | Create temporary tables | Databases | To use CREATE TEMPORARY TABLE | | Create view | Tables | To create new views | | Create user | Server Admin | To create new users | | Delete | Tables | To delete existing rows | | Drop | Databases,Tables | To drop databases, tables, and views | | Drop role | Server Admin | To drop roles | | Event | Server Admin | To create, alter, drop and execute events | | Execute | Functions,Procedures | To execute stored routines | | File | File access on server | To read and write files on the server | | Grant option | Databases,Tables,Functions,Procedures | To give to other users those privileges you possess | | Index | Tables | To create or drop indexes | | Insert | Tables | To insert data into tables | | Lock tables | Databases | To use LOCK TABLES (together with SELECT privilege) | | Process | Server Admin | To view the plain text of currently executing queries | | Proxy | Server Admin | To make proxy user possible | | References | Databases,Tables | To have references on tables | | Reload | Server Admin | To reload or refresh tables, logs and privileges | | Replication client | Server Admin | To ask where the slave or master servers are | | Replication slave | Server Admin | To read binary log events from the master | | Select | Tables | To retrieve rows from table | | Show databases | Server Admin | To see all databases with SHOW DATABASES | | Show view | Tables | To see views with SHOW CREATE VIEW | | Shutdown | Server Admin | To shut down the server | | Super | Server Admin | To use KILL thread, SET GLOBAL, CHANGE MASTER, etc. | | Trigger | Tables | To use triggers | | Create tablespace | Server Admin | To create/alter/drop tablespaces | | Update | Tables | To update existing rows | | Usage | Server Admin | No privileges - allow connect only | | BACKUP_ADMIN | Server Admin | | | RESTORE_ADMIN | Server Admin | | | SYSTEM_USER | Server Admin | | | SYSTEM_VARIABLES_ADMIN | Server Admin | | | ROLE_ADMIN | Server Admin | | | CONNECTION_ADMIN | Server Admin | | | PLACEMENT_ADMIN | Server Admin | | | DASHBOARD_CLIENT | Server Admin | | | RESTRICTED_TABLES_ADMIN | Server Admin | | | RESTRICTED_STATUS_ADMIN | Server Admin | | | RESTRICTED_VARIABLES_ADMIN | Server Admin | | | RESTRICTED_USER_ADMIN | Server Admin | | | RESTRICTED_CONNECTION_ADMIN | Server Admin | | | RESTRICTED_REPLICA_WRITER_ADMIN | Server Admin | | | RESOURCE_GROUP_ADMIN | Server Admin | | +---------------------------------+---------------------------------------+-------------------------------------------------------+ 49 rows in set (0.00 sec)

MySQLの互換性

TiDB のSHOW PRIVILEGESステートメントは MySQL と完全な互換性があります。互換性の違いが見つかった場合は、 バグを報告 .

こちらも参照

このページは役に立ちましたか?

Playground
新規
登録なしで TiDB の機能をワンストップでインタラクティブに体験できます。
製品
TiDB Cloud
TiDB
価格
PoC お問い合わせ
エコシステム
TiKV
TiFlash
OSS Insight
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.