Granting privileges on all tables,sequences , views, procedures
От
Adarsh Sharma
Тема
Granting privileges on all tables,sequences , views, procedures
Дата
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
Дата: