|
Aurora MySQL
|
2 版:
ALTER,ALTER ROUTINE,
CREATE,CREATE ROUTINE,CREATE
TEMPORARY TABLES,CREATE USER,CREATE
VIEW,DELETE,DROP,
EVENT,EXECUTE,GRANT
OPTION,INDEX,INSERT,
LOAD FROM S3,LOCK TABLES,
PROCESS,REFERENCES,
RELOAD,REPLICATION CLIENT,
REPLICATION SLAVE,SELECT,
SELECT INTO S3,SHOW DATABASES,
SHOW VIEW,TRIGGER,
UPDATE
|
— |
|
第 3 版:
ALTER,APPLICATION_PASSWORD_ADMIN,
ALTER ROUTINE,CONNECTION_ADMIN,
CREATE,CREATE ROLE,CREATE
ROUTINE,CREATE TEMPORARY TABLES,
CREATE USER,CREATE VIEW,
DELETE,DROP,DROP ROLE,
EVENT,EXECUTE,INDEX,
INSERT,LOCK TABLES,
PROCESS,REFERENCES,
RELOAD,REPLICATION CLIENT,
REPLICATION SLAVE,ROLE_ADMIN,
SET_USER_ID,SELECT,SHOW
DATABASES,SHOW VIEW,TRIGGER,
UPDATE,XA_RECOVER_ADMIN
從 Aurora MySQL 3.04.0 版開始,主要使用者也會取得 SHOW_ROUTINE 權限。
從 Aurora MySQL 3.09.0 版開始,主要使用者也會取得 FLUSH_OPTIMIZER_COSTS、FLUSH_STATUS、FLUSH_TABLES 和 FLUSH_USER_RESOURCES 權限。
|
rds_superuser_role
如需 rds_superuser_role 的詳細資訊,請參閱 角色型權限模型。
|
|
8.4 版:
ALTER,ALLOW_NONEXISTENT_DEFINER,
APPLICATION_PASSWORD_ADMIN,
ALTER ROUTINE,CONNECTION_ADMIN,
CREATE,CREATE ROLE,CREATE
ROUTINE,CREATE TEMPORARY TABLES,
CREATE USER,CREATE VIEW,
DELETE,DROP,DROP ROLE,
EVENT,EXECUTE,
FLUSH_OPTIMIZER_COSTS,FLUSH_PRIVILEGES,
FLUSH_STATUS,FLUSH_TABLES,
FLUSH_USER_RESOURCES,
INDEX,INSERT,
LOCK TABLES,OPTIMIZE_LOCAL_TABLE,
PROCESS,REFERENCES,
RELOAD,REPLICATION CLIENT,
REPLICATION SLAVE,ROLE_ADMIN,
SELECT,SET_ANY_DEFINER,
SHOW DATABASES,SHOW_ROUTINE,
SHOW VIEW,TRIGGER,
UPDATE,XA_RECOVER_ADMIN
|
rds_superuser_role
如需 rds_superuser_role 的詳細資訊,請參閱 角色型權限模型。
|
|
Aurora PostgreSQL
|
LOGIN,NOSUPERUSER,
INHERIT,CREATEDB,
CREATEROLE,NOREPLICATION,VALID
UNTIL 'infinity'
|
RDS_SUPERUSER
如需 RDS_SUPERUSER 的詳細資訊,請參閱 了解 PostgreSQL 角色和許可。
|