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
oracle如何删除角色,oracle 角色创建和删除
最新推荐文章于 2021-08-16 23:31:29 发布