PostgreSQL 授予用户指定 table 只读权限

PostgreSQL About 207 words

创建用户

CREATE USER my_user PASSWORD 'pwd2024';

授予指定表的只读权限

GRANT SELECT ON table1, table2 TO my_user;

参考

https://www.postgresql.org/docs/16/ddl-priv.html

https://www.postgresql.org/docs/16/sql-createrole.html

Views: 471 · Posted: 2024-07-12

————        END        ————

Give me a Star, Thanks:)

https://github.com/fendoudebb/LiteNote

扫描下方二维码关注公众号和小程序↓↓↓

扫描下方二维码关注公众号和小程序↓↓↓


Today On History
Browsing Refresh