Granting privileges on all tables,sequences , views, procedures

Поиск
Список
Период
Сортировка
Искать
От
Adarsh Sharma
Тема
Granting privileges on all tables,sequences , views, procedures
Дата
в 01:41:22
Msg-id
4DD1FC73.7000305@orkash.com
Список
Дерево обсуждения
Granting privileges on all tables,sequences , views, procedures Adarsh Sharma <adarsh.sharma@orkash.com>
Re: Granting privileges on all tables,sequences , views, procedures Grzegorz Szpetkowski <gszpetkowski@gmail.com>
Re: Granting privileges on all tables,sequences , views, procedures Christopher Opena <counterveil@gmail.com>
Re: Granting privileges on all tables,sequences , views, procedures Christopher Opena <counterveil@gmail.com>
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
В списке pgsql-general по дате отправления
От: Bernardo Telles
Дата:
От: Adarsh Sharma
Дата:
Сообщение: Memcached for Database server
FAQ