Re: granting privileges
| От | Najib Abi Fadel |
|---|---|
| Тема | Re: granting privileges |
| Дата | |
| Msg-id | 004a01c4d782$4e35de50$f664a8c0@najib обсуждение исходный текст |
| Ответ на | granting privileges (Nageshwar Rao <NageshwarR@PLANETASIA.COM>) |
| Список | pgsql-general |
Hi Nageshwar try this command i think it's what you need.
psql -t -d DataBaseName -c "select tablename from pg_tables where schemaname='theSchemaName' " | xargs -i psql -t -d DataBaseName -c "grant select on {} to nabifadel"
Najib.
Programmer at Saint-Joseph University
Lebanon
----- Original Message -----From: Nageshwar RaoSent: Wednesday, December 01, 2004 7:36 AMSubject: [GENERAL] granting privilegesHow to grant privileges to all objects( tables,sequences etc) in specific schema, I mean I want to give users select,insert,delete and update to all objects in the schema in one sql statement.I know
Grant select,insert,update,delete on table_name to user_name. But this is for individual table .
В списке pgsql-general по дате отправления: