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)