1、创建用户,并设置密码:
create user user1 identified by 'pwd1';
2、把角色授权给用户(dbduser是普通角色):
grant dbduser to user1;
3、把用户模式授权给用户:
grant usage on schema schema1 to user1;
4、把表授权给用户,仅限select权限:
grant select on schema1.table1 to user1;
1、创建用户,并设置密码:
create user user1 identified by 'pwd1';
2、把角色授权给用户(dbduser是普通角色):
grant dbduser to user1;
3、把用户模式授权给用户:
grant usage on schema schema1 to user1;
4、把表授权给用户,仅限select权限:
grant select on schema1.table1 to user1;