oracle 创建新用户

最新推荐文章于 2024-04-07 14:33:49 发布

原创最新推荐文章于 2024-04-07 14:33:49 发布 · 1k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#oracle #user #system #insert #delete

#sql

收录于

oracle 专栏收录该内容

26 篇文章

订阅专栏

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

-- 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;