Re: [GENERAL] User postgres unable to revoke privileges?

2013-06-09 Thread Tom Lane
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes: Le 2013-06-06 à 17:59, Tom Lane a écrit : Note where the fine manual says: schema_name The name of an existing schema. Each target_role must have CREATE privileges for each specified schema. There was some debate

Re: [GENERAL] User postgres unable to revoke privileges?

2013-06-07 Thread François Beausoleil
Le 2013-06-06 à 17:59, Tom Lane a écrit : =?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes: regress=# ALTER DEFAULT PRIVILEGES FOR ROLE dataanalysts IN SCHEMA public REVOKE SELECT ON TABLES FROM dataanalysts; ERROR: permission denied for schema public I'm logged in as

[GENERAL] User postgres unable to revoke privileges?

2013-06-06 Thread François Beausoleil
Hi all! I would like to remove the second line from default privileges, because dataanalysts can't create new tables in public anyway: # psql -U postgres psql (9.1.9) Type help for help. regress=# \ddp Default access privileges Owner |Schema| Type |

Re: [GENERAL] User postgres unable to revoke privileges?

2013-06-06 Thread Tom Lane
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes: regress=# ALTER DEFAULT PRIVILEGES FOR ROLE dataanalysts IN SCHEMA public REVOKE SELECT ON TABLES FROM dataanalysts; ERROR: permission denied for schema public I'm logged in as postgres, the database superuser. Why am I