Re: Granting privileges on all tables,sequences , views, procedures

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."
http://www.postgresql.org/docs/8.0/static/sql-altertable.html

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(dot)sharma(at)orkash(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>