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)

この記事が気に入ったらサポートをしてみませんか?