User postgres unable to revoke privileges?

From: François Beausoleil <francois(at)teksol(dot)info>
To: Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: User postgres unable to revoke privileges?
Date: 2013-06-06 15:40:13
Message-ID: F411D60E-2A39-4112-A530-7EDF174DD509@teksol.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 | Access privileges
--------------+--------------+-------+-----------------------------------
dataanalysts | dataanalysts | table | dataanalysts=arwdDxt/dataanalysts
dataanalysts | public | table | dataanalysts=r/dataanalysts
svanalytics | public | table | dataanalysts=r/svanalytics
(3 rows)

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 getting a permission denied?

Thanks!
François Beausoleil

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-06-06 16:32:55 Re: Streaming replication with sync slave, but disconnects due to missing WAL segments
Previous Message Vinicio Nocciolini 2013-06-06 14:44:36 plpgsql : looping over multidimensional array : getting NULL for subdimension