huawei--创建用户，角色，授权

today1858

于 2010-12-01 20:26:00 发布

阅读量816

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库--用户文章标签： table session database dictionary jobs insert

本文链接：https://blog.youkuaiyun.com/today1858/article/details/6048648

数据库--用户专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍了在Oracle数据库中创建用户、分配和撤销各种权限的过程，包括授予DBA、资源和其他特定权限，以及如何使用sys.dbms_sys_sql包执行高级操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

create user icd identified by icd default tablespace icd_service temporary tablespace ICD_TEMP
grant dba to icd with admin option
grant execute on sys.dbms_sys_sql to icd with grant option
grant unlimited tablespace to icd
GRANT SELECT ON SYS.DBA_JOBS TO ICD with grant option
/
DROP ROLE ICD_VDNUSER
CREATE ROLE ICD_INTERNAL
GRANT CREATE SESSION TO ICD_VDNUSER
GRANT DBA TO ICD_INTERNAL
GRANT EXECUTE on sys.dbms_sys_sql to ICD_INTERNAL
GRANT SELECT ON SYS.DBA_JOBS TO ICD_INTERNAL
GRANT CREATE ANY TABLE TO ICD_VDNUSER
GRANT EXECUTE on spInsertRecordInfoLog TO ICD_VDNUSER
GRANT SELECT ON t_CustLevel to ICD_VDNUSER
/

REVOKE DBA FROM icd1
GRANT RESOURCE ,CONNECT TO icd1
GRANT UNLIMITED TABLESPACE TO icd1
GRANT ALTER SESSION TO icd1
GRANT EXECUTE ANY PROCEDURE TO icd1
GRANT SELECT ANY DICTIONARY TO icd1
GRANT SELECT ANY TABLE TO icd1
GRANT SELECT ANY SEQUENCE TO icd1
GRANT INSERT ANY TABLE TO icd1
GRANT EXP_FULL_DATABASE TO icd1
GRANT IMP_FULL_DATABASE TO icd1
GRANT DELETE ANY TABLE TO icd1
GRANT UPDATE ANY TABLE TO icd1
GRANT DEBUG ANY PROCEDURE TO icd1
GRANT DEBUG CONNECT SESSION TO icd1
/