Re: BUG #3499: no owner privileges in information_schema.table_privileges

Any idea what the spec says about this?

On Mon, Jul 30, 2007 at 10:28:37PM +0000, Kirill Simonov wrote:
>
> The following bug has been logged online:
>
> Bug reference: 3499
> Logged by: Kirill Simonov
> Email address: xi(at)gamma(dot)dn(dot)ua
> PostgreSQL version: 8.2.4
> Operating system: Linux
> Description: no owner privileges in
> information_schema.table_privileges
> Details:
>
> Owner privileges are not listed in the output of the
> information_schema.table_privileges view when no privileges are granted to
> other users. However if at least one GRANT statement was applied to a
> table, the table owner appears in the "table_privileges".
>
> The following example illustrates the problem:
>
>
> -- initialize the test environment: create two users: test_owner and
> test_user and create a table test_table, which owner is test_owner.
> # create user test_owner;
> # create user test_user;
> # create table test_table ();
> # alter table test_table owner to test_owner;
>
> -- table_privileges contains no rows for 'test_tables'
> # select grantee, privilege_type from information_schema.table_privileges
> where table_name = 'test_table';
> (0 rows)
>
> -- add a privilege for some other user.
> # grant select on test_table to test_user;
>
> -- suddenly, not only the test_user privileges appear in "table_privileges",
> but the "test_owner" privileges appear as well.
> # select grantee, privilege_type from information_schema.table_privileges
> where table_name = 'test_table';
> grantee | privilege_type
> ------------+----------------
> test_owner | SELECT
> test_owner | DELETE
> test_owner | INSERT
> test_owner | UPDATE
> test_owner | REFERENCES
> test_owner | TRIGGER
> test_user | SELECT
> (7 rows)
>
> -- drop test_*.
> # drop table test_table;
> # drop user test_user;
> # drop user test_owner;
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Decibel!, aka Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)