testdb=# \z itemとREVOKE
testdb=# \z item
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
--------+------+-------+---------------------------+-------------------+----------
public | item | table | postgres=arwdDxt/postgres+| |
| | | user1=arwdDxt/postgres | |
(1 row)
testdb=# REVOKE INSERT,UPDATE ON item FROM user1;
REVOKE
testdb=# REVOKE INSERT,UPDATE ON item FROM user1;
REVOKE
testdb=# \z item
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
--------+------+-------+---------------------------+-------------------+----------
public | item | table | postgres=arwdDxt/postgres+| |
| | | user1=rdDxt/postgres | |
(1 row)
testdb=# REVOKE DELETE ON item FROM user1;
REVOKE
testdb=# \z item
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
--------+------+-------+---------------------------+-------------------+----------
public | item | table | postgres=arwdDxt/postgres+| |
| | | user1=rDxt/postgres | |
(1 row)
この記事が気に入ったらサポートをしてみませんか?