Hi All friends. Thanks for you guys reply my questions. You helps me a lot.
THank you billions. Another help. THanks.
After I create table and roles. I want to double check I grant the proper
privileges to the users. I can
use \dp and \z command to check the objects privilege. I can user pg_authid
to check the system privilege grantee to the users. Am I right??????? the
below is what I get from my test database.
Q : what's the differences between \dp and \z.
Thanks.
Regards.
Grace
rrp=# \dp
Access privileges for database "rrp"
Schema | Name | Type | Access privileges
--------+------+----------+---------------------------------------------------
rrp | c | sequence |
rrp | p | sequence |
rrp | se1 | sequence |
rrp | t1 | table |
{grace=arwdxt/grace,user1=ar/grace,user2=r/grace}
rrp | t2 | table | {grace=arwdxt/grace,user1=r/grace}
rrp=# \z
Access privileges for database "rrp"
Schema | Name | Type | Access privileges
--------+------+----------+---------------------------------------------------
rrp | c | sequence |
rrp | p | sequence |
rrp | se1 | sequence |
rrp | t1 | table |
{grace=arwdxt/grace,user1=ar/grace,user2=r/grace}
rrp | t2 | table | {grace=arwdxt/grace,user1=r/grace}
(5 rows)rrp=# select
rolname,rolsuper,rolinherit,rolcreaterole,rolcreatedb,rolcanlogin from
pg_authid;
rolname | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin
---------+----------+------------+---------------+-------------+-------------
gpadmin | t | t | t | t | t
grace | f | t | f | t | t
user1 | f | t | f | f | t
user2 | f | t | f | f | t
user4 | f | t | f | f | t
(5 rows)
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/double-check-the-role-has-what-s-kind-of-the-privilege-And-the-same-for-the-objects-Thanks-tp5605564p5605564.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
