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:
>=20
> The following bug has been logged online:
>=20
> Bug reference:      3499
> Logged by:          Kirill Simonov
> Email address:      xi@gamma.dn.ua
> PostgreSQL version: 8.2.4
> Operating system:   Linux
> Description:        no owner privileges in
> information_schema.table_privileges
> Details:=20
>=20
> 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".
>=20
> The following example illustrates the problem:
>=20
>=20
> -- 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;
>=20
> -- table_privileges contains no rows for 'test_tables'
> # select grantee, privilege_type from information_schema.table_privileges
> where table_name =3D 'test_table';
> (0 rows)
>=20
> -- add a privilege for some other user.
> # grant select on test_table to test_user;
>=20
> -- suddenly, not only the test_user privileges appear in "table_privilege=
s",
> but the "test_owner" privileges appear as well.
> # select grantee, privilege_type from information_schema.table_privileges
> where table_name =3D 'test_table';
>   grantee   | privilege_type=20
> ------------+----------------
>  test_owner | SELECT
>  test_owner | DELETE
>  test_owner | INSERT
>  test_owner | UPDATE
>  test_owner | REFERENCES
>  test_owner | TRIGGER
>  test_user  | SELECT
> (7 rows)
>=20
> -- drop test_*.
> # drop table test_table;
> # drop user test_user;
> # drop user test_owner;
>=20
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>=20

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