Re: Granting privileges on all tables,sequences , views, procedures
От
Christopher Opena
Тема
Re: Granting privileges on all tables,sequences , views, procedures
Дата
Msg-id
BANLkTikeboUG7062Q7W_z_k4w2rsF9s+cA@mail.gmail.com
Ответ на
Granting privileges on all tables,sequences , views, procedures (Adarsh Sharma)
Список
Дерево обсуждения
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>
Per 8.0 documentation, in order to ALTER a table (including rename), you have to be the owner of a table:
"You must own the table to use ALTER TABLE; except for ALTER TABLE OWNER, which may only be executed by a superuser."
If you want to grant ownership of every table in a database to a specific user, you should be able to:
SELECT exec('alter table '||table_name||' OWNER TO {user}') FROM information_schema.tables WHERE table_schema='{schema}'
{user} = the user you want to grant to (looks like 'neha' in your case)
{schema} = schema search path for your database (probably 'public' if you haven't changed it)
HTH,
-Chris.
On Mon, May 16, 2011 at 9:41 PM, Adarsh Sharma <adarsh.sharma@orkash.com> wrote:
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
В списке pgsql-general по дате отправления
