PostgreSQL 权限

GRANT 授权、REVOKE 收权；可按库、表、列粒度给 SELECT/INSERT/UPDATE/DELETE 等权限。

Advanced

Key PointsPostgreSQL,GRANT,REVOKE,权限,角色

讲解

GRANT 授权、REVOKE 收权；可按库、表、列粒度给 SELECT/INSERT/UPDATE/DELETE 等权限。

示例

SQL

CREATE USER app WITH PASSWORD 'secret';
GRANT SELECT, INSERT ON company TO app;
GRANT ALL PRIVILEGES ON DATABASE mydb TO app;
REVOKE INSERT ON company FROM app;

Output

CREATE ROLE
GRANT
GRANT
REVOKE

讲解

GRANT 授权、REVOKE 收权；可按库、表、列粒度给 SELECT/INSERT/UPDATE/DELETE 等权限。

示例

SQL

CREATE USER app WITH PASSWORD 'secret';
GRANT SELECT, INSERT ON company TO app;
GRANT ALL PRIVILEGES ON DATABASE mydb TO app;
REVOKE INSERT ON company FROM app;

Output

CREATE ROLE
GRANT
GRANT
REVOKE

Friends & Partners

新华字典在线查字汉语词典成语大全歇后语大全古诗词鉴赏网络热词专业术语大全