oracle 角色创建和删除

super1900

于 2009-06-06 10:58:00 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

分类专栏：技术专题文章标签： oracle sql manager user table

本文链接：https://blog.youkuaiyun.com/super1900/article/details/4246871

技术专题专栏收录该内容

20 篇文章

订阅专栏

本文介绍了一种在数据库中通过SQL命令创建、修改、分配角色的方法，并详细解释了如何设置默认角色、启用禁用角色、从用户移除角色及最终删除角色的过程。

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

1.create roles
sql> create role sales_clerk;
sql> create role hr_clerk identified by bonus;
sql> create role hr_manager identified externally;
add privs to roles
SQL>grant select on scott.users to test_user

comment:
scott.users is a table
test_user is a account

2.modify role
sql> alter role sales_clerk identified by commission;
sql> alter role hr_clerk identified externally;
sql> alter role hr_manager not identified;
3.assigning roles
sql> grant sales_clerk to scott;
sql> grant hr_clerk to hr_manager;
sql> grant hr_manager to scott with admin option;
4.establish default role
sql> alter user scott default role hr_clerk,sales_clerk;
sql> alter user scott default role all;
sql> alter user scott default role all except hr_clerk;
sql> alter user scott default role none;
5.enable and disable roles
sql> set role hr_clerk;
sql> set role sales_clerk identified by commission;
sql> set role all except sales_clerk;
sql> set role none;
6.remove role from user
sql> revoke sales_clerk from scott;
sql> revoke hr_manager from public;
7.remove role
sql> drop role hr_manager;
8.display role information