From: | leaf_yxj <leaf_yxj(at)163(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | double check the role has what's kind of the privilege? And the same for the objects. Thanks. |
Date: | 2012-03-30 02:49:31 |
Message-ID: | 1333075771550-5605564.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Travers | 2012-03-30 02:53:35 | Re: double check the role has what's kind of the privilege? And the same for the objects. Thanks. |
Previous Message | Scott Marlowe | 2012-03-30 02:45:25 | Re: could not read block... how could I identify/fix |