Granting privileges on all tables,sequences , views, procedures

From: Adarsh Sharma <adarsh(dot)sharma(at)orkash(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Granting privileges on all tables,sequences , views, procedures
Date: 2011-05-17 04:41:23
Message-ID: 4DD1FC73.7000305@orkash.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear all,

Today I grant a user all privileges to all tables in a database by

grant all privileges on svo_data_social to neha ;
grant all privileges on svo_phrases to neha ;
.. . .....
.....
...

Now i find it very uncomfort to grant privileges one by one table.

Is there a simple way to grant privileges on all tables, views,
sequences etc in a database.

Also , after granting all privileges , rename command is not granted.

Is it impossible to grant alter & drop privileges to user which is
granted to only the user who created the object.

What is ALL privileges comprised of ?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adarsh Sharma 2011-05-17 05:09:14 Memcached for Database server
Previous Message Bernardo Telles 2011-05-17 02:17:45 Re: How do we combine and return results from multiple queries in a loop?