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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to