级别权限
GBase
8s 对于序列和同义词提供两种操作的权限管理,Select 和 Alter,其语法
如下:
授权语法示例如下:
收回权限语法示例如下:
【示例 11.1.21】
GRANT USAGE ON TYPE ty_a TO usera, userb, userc ;
GRANT UNDER ON TYPE ty_a TO PUBLIC;
REVOKE UNDER ON ty_a FROM PUBLIC;
REVOKE USAGE ON ty_a FROM usera, userb, userc;
ALL
Owner .
SELECT
ALTER
synonym
,
ON
sequence
GRANT ALL ON sequence_1 TO usera, userb, userc ;
GRANT SELECT ON synonym_2 TO PUBLIC;
REVOKE SELECT ON synonym_2 FROM PUBLIC;
REVOKE ALL ON sequence_1 FROM usera, userb, userc;
GBase 8s 安全技术指南
南大通用数据技术股份有限公司
- 20 -
5 标记与强制访问控制