数据库引擎 |
系统权限 |
数据库角色 |
MySQL 和 MariaDB |
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW
DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE,
REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER
ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* WITH GRANT OPTION,
REPLICATION SLAVE
|
— |
PostgreSQL |
CREATE ROLE, CREATE DB, PASSWORD VALID UNTIL INFINITY, CREATE EXTENSION, ALTER EXTENSION, DROP
EXTENSION, CREATE TABLESPACE, ALTER <OBJECT> OWNER, CHECKPOINT,
PG_CANCEL_BACKEND(), PG_TERMINATE_BACKEND(), SELECT
PG_STAT_REPLICATION, EXECUTE PG_STAT_STATEMENTS_RESET(), OWN
POSTGRES_FDW_HANDLER(), OWN POSTGRES_FDW_VALIDATOR(), OWN
POSTGRES_FDW, EXECUTE PG_BUFFERCACHE_PAGES(), SELECT PG_BUFFERCACHE
|
RDS_SUPERUSER
有关 RDS_SUPERUSER 的更多信息，请参阅了解 PostgreSQL 角色和权限。 |
Oracle |
ALTER DATABASE LINK, ALTER PUBLIC DATABASE LINK, DROP ANY DIRECTORY, EXEMPT ACCESS POLICY,
EXEMPT IDENTITY POLICY, GRANT ANY OBJECT PRIVILEGE, RESTRICTED
SESSION, EXEMPT REDACTION POLICY
|
AQ_ADMINISTRATOR_ROLE, AQ_USER_ROLE, CONNECT, CTXAPP, DBA,
EXECUTE_CATALOG_ROLE, RECOVERY_CATALOG_OWNER, RESOURCE,
SELECT_CATALOG_ROLE
|
Microsoft SQL Server |
ADMINISTER BULK OPERATIONS, ALTER ANY CONNECTION, ALTER ANY CREDENTIAL, ALTER ANY EVENT
SESSION, ALTER ANY LINKED SERVER, ALTER ANY LOGIN, ALTER ANY
SERVER AUDIT, ALTER ANY SERVER ROLE, ALTER SERVER STATE, ALTER
TRACE, CONNECT SQL, CREATE ANY DATABASE, VIEW ANY
DATABASE, VIEW ANY DEFINITION, VIEW SERVER STATE, ALTER ON ROLE
SQLAgentOperatorRole
|
DB_OWNER（数据库级别角色）、PROCESSADMIN（服务器级别角色）、SETUPADMIN（服务器级别角色）、SQLAgentUserRole（数据库级别角色）
|