从Oracle到PG-PostgreSQL中的用户权限注意点

Oracle中的对象权限，通常指schema(或user)下面具体对象的权限，如schema（或user）下的表、索引等。

但在postgresql中，集簇内的tablespace、database、scheme、table等都统称对象。所以，pg权限包括user或role、tablespace、database、schema、表、索引等层级。

更多的权限对象，通过grant语句查看：

(postgres@[local]:5432)[postgres]#\h grant
Command: GRANT
Description: define access privileges
Syntax:
GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER }
 [, ...] | ALL [ PRIVILEGES ] }
 ON { [ TABLE ] table_name [, ...]
 | ALL TABLES IN SCHEMA schema_name [, ...] }
 TO role_specification [, ...] [ WITH GRANT OPTION ]
GRANT { { SELECT | INSERT | UPDATE | REFERENCES } ( column_name [, ...] )
 [, ...] | ALL [ PRIVILEGES ] ( column_name [, ...] ) }
 ON [ TABLE ] table_name [, ...]
 TO role_specification [, ...] [ WITH GRANT OPTION ]
GRANT { { USAGE | SELECT | UPDATE }
 [, ...] | ALL [ PRIVILEGES ] }
 ON { SEQUENCE sequence_name [, ...]
 | ALL SEQUENCES IN SCHEMA schema_name