ORACLE 角色、授权、表空间授权、授予用户使用表空间、dba的赋予与取消

授权某个权限给某个角色:

GRANT DELETE ANY TABLE TO "UCITROLE";  将DELETE ANY TABLE 权限授权给UCITROLE角色

权限:

ALTER ANY INDEX
ALTER ANY TABLE
ALTER ANY TRIGGER
CREATE ANY INDEX
CREATE ANY JOB
CREATE ANY SEQUENCE
CREATE ANY TABLE
CREATE ANY TRIGGER
CREATE ANY VIEW
CREATE SEQUENCE

CREATE SESSION
DELETE ANY TABLE
DROP ANY TABLE
EXECUTE ANY PROGRAM
INSERT ANY TABLE
ON COMMIT REFRESH
SELECT ANY SEQUENCE
SELECT ANY TABLE
SELECT ANY TRANSACTION
UPDATE ANY TABLE

表空间给角色授权:

alter user 用户名 quota unlimited on 表空间;

回收用户dba的角色 :
revoke dba  from user

dba角色赋予用户:
grant dba  to user

原文地址:https://www.cnblogs.com/jifeng/p/1978511.html