information_schema.table_privileges

From: "Alexi Gen" <sqlcatz(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: information_schema.table_privileges
Date: 2007-03-14 08:08:52
Message-ID: BAY21-F2301EB9AE61C85F5CDEF56AD730@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am not able to understand 2 things about table_privileges and is_grantable.
Can someone please help out with this?

Create a table (acctmast).
Check information_schema.table_privileges - there will not be any records
for this table.
Grant only SELECT permissions to a single user - (dbasr).
A single record appears for this relationship (acctmast - dbasr).
Apart from the above there are 6 more records - all for the postgres user
for the following (SELECT, DELETE, INSERT, UPDATE, REFERENCES, TRIGGER).

(a) Why do these records appear only when the GRANT statement for the
(acctmast - dbasr) is executed? They should have been displayed even before
the GRANT was executed for dbasr.
(b) [is_grantable] has a value of "NO".
What is the meaning of this column and value?
The documentation says that "YES if the privilege is grantable, NO if not".
A Record appears in this table only AFTER the privilege has been granted.
So why does "NO" appear in the column?

Cheers!

_________________________________________________________________
Catch the complete World Cup coverage with MSN
http://content.msn.co.in/Sports/Cricket/Default.aspx

Browse pgsql-general by date

  From Date Subject
Next Message Arkan 2007-03-14 08:24:01 PgSql on Vista?
Previous Message Sim Zacks 2007-03-14 07:38:04 Re: insert rule instead oddity