How to grant table in PostgreSQL?

最新推荐文章于 2024-07-25 16:10:33 发布

wish366

最新推荐文章于 2024-07-25 16:10:33 发布

阅读量227

点赞数

分类专栏：其他文章标签： postgresql

本文链接：https://blog.csdn.net/wish366/article/details/116993110

版权

其他专栏收录该内容

7 篇文章

订阅专栏

常常漏掉这一句：grant usage on schema...

-- Permissions

grant usage on schema "A" to "B"; 
grant usage on schema "A" to "C"; 

ALTER TABLE "A".tablename OWNER TO "A" ;
GRANT ALL ON TABLE "A".tablename TO "A" ;
GRANT SELECT ON TABLE "A".tablename TO "B" ;
GRANT SELECT ON TABLE "A".tablename TO "C" ;