oracle 创建新用户

最新推荐文章于 2023-05-13 12:31:21 发布

物润声无

最新推荐文章于 2023-05-13 12:31:21 发布

阅读量998

点赞数

分类专栏： oracle 文章标签： oracle user system insert delete sql

本文链接：https://blog.youkuaiyun.com/gjswxhb/article/details/6214530

版权

oracle 专栏收录该内容

26 篇文章

订阅专栏

本文介绍了如何在 Oracle 数据库中创建用户 PERSONNEL_MANAGE，并设置默认表空间、临时表空间等属性。此外，还详细说明了如何授予和撤销角色及系统权限，包括 AQ_ADMINISTRATOR_ROLE 和 ADMINISTER ANY SQL TUNING SET 等高级权限。

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

-- Create the user
create user PERSONNEL_MANAGE
identified by "MWQ"
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT
quota 1024m on sysaux;
-- Grant/Revoke role privileges
grant aq_administrator_role to PERSONNEL_MANAGE with admin option;
-- Grant/Revoke system privileges
grant administer any sql tuning set to PERSONNEL_MANAGE with admin option;

-- Modify the user
alter user PERSONNEL_MANAGE
identified by MWQ;
-- Grant/Revoke object privileges
grant select, insert, update, delete on ALL_APPLY to PERSONNEL_MANAGE;
-- Grant/Revoke role privileges
revoke AQ_ADMINISTRATOR_ROLE from PERSONNEL_MANAGE;
grant connect to PERSONNEL_MANAGE with admin option;
grant dba to PERSONNEL_MANAGE with admin option;
-- Grant/Revoke system privileges
grant administer sql tuning set to PERSONNEL_MANAGE with admin option;