人大金仓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;