人大金仓V8R6进阶授权操作
授权用户myuser在模式myschema 单表的所有权限
GRANT ALL ON TABLE "myschema"."mytable" to "myuser";
授权用户myuser在模式myschema 单表的查询权限
GRANT SELECT ON TABLE "myschema"."mytable" to "myuser";
授权用户myuser 在模式myschema 所有表的查询权限
GRANT SELECT ON ALL TABLES IN SEHEMA myschema TO myuser ；
授权用户myuser在模式myschema 所有表的所有权限
方法1.GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES, TRIGGER, TRUNCATE ON ALL TABLES IN SEHEMA myschema TO myuser ；
方法2.GRANT ALL ON ALL TABLES IN SCHEMA myschema TO myuser ;
收回数据库 ythgisdb public权限
revoke connect on database ythgisdb from public;
赋予用户数据库ythgisdb的连接权限
grant connect on database ythgisdb to user01;