通过以下步骤,创建用户,并对用户权限进行操作:
1、创建用户
CREATE ROLE User1 LOGIN PASSWORD '123456';
2、授予表查询权限
1、创建用户
CREATE ROLE User1 LOGIN PASSWORD '123456';
2、授予表查询权限
grant select on table tablename to User1 ;
3、撤销用户对表操作的权限
revoke insert,delete,update,select on table tablename to User1 ;
管理对象权限如下:
Table . Object Privileges | |
Object Type | Privileges |
Tables, Views, Sequences | SELECT INSERT UPDATE DELETE RULE ALL |
External Tables | SELECT RULE ALL |
Databases | CONNECT CREATE TEMPORARY | TEMP ALL |
Functions | EXECUTE |
Procedural Languages | USAGE |
Schemas | CREATE USAGE ALL |
Custom Protocol | SELECT INSERT UPDATE DELETE RULE ALL |