我平时使用数据库很少会有赋权的操作,但是最近有个场景需要给某个用户设置只能操作哪些数据库和表还有序列。我分享一下我的经验,我用的是 PostgreSQL 数据库。
GRANT privilege [, ...] ON object TO {user | group | PUBLIC} [, ...] [WITH GRANT OPTION];
GRANT SELECT, INSERT ON test TO zhangsan;
REVOKE privilege [, ...] ON object FROM {user | group | PUBLIC} [, ...] [CASCADE | RESTRICT];
REVOKE SELECT ON test FROM zhangsan;
SELECT * FROM pg_user;
CREATE USER zhangsan WITH PASSWORD '123456';
DROP USER zhangsan;
CREATE DATABASE test;
DROP DATABASE IF EXISTS test;
REVOKE ALL privileges ON DATABASE "test" FROM zhangsan;
GRANT CONNECT, CREATE, TEMPORARY ON DATABASE "test" TO zhangsan;
GRANT SELECT, INSERT, UPDATE, DELETE
ON ALL TABLES IN SCHEMA PUBLIC
TO zhangsan;
GRANT SELECT, UPDATE, USAGE ON ALL SEQUENCES IN SCHEME PUBLIC TO zhangsan;
GRANT USAGE ON ALL SEQUENCES IN SCHEME PUBLIC TO zhangsan;
免责申明:
本文系转载,版权归原作者所有,如若侵权请联系我们进行删除!
《数据治理行业实践白皮书》下载地址:https://fs80.cn/4w2atu
《数栈V6.0产品白皮书》下载地址:https://fs80.cn/cw0iw1
想了解或咨询更多有关袋鼠云大数据产品、行业解决方案、客户案例的朋友,浏览袋鼠云官网:https://www.dtstack.com/?src=bbs
同时,欢迎对大数据开源项目有兴趣的同学加入「袋鼠云开源框架钉钉技术群」,交流最新开源技术信息,群号码:30537511,项目地址:https://github.com/DTStack