=?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
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
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 |
=?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