greenplum 权限说明

Table 2. 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

Note: Privilegesmust be granted for each object individually. For example, granting ALL on a database does not grant fullaccess to the objects within that database. It only grants all of thedatabase-level privileges (CONNECT, CREATE, TEMPORARY) to the database itself.

 

使用grant语句赋予角色对象权限，使用revoke收回权限

（1）赋予权限

yueworld_db=# grant insert,delete,update,select on table t1 to mch;                                                 

GRANT

yueworld_db=#

（2）收回权限

yueworld_db=# revoke insert,delete,update,select on table t1 from mch;

REVOKE

yueworld_db=#