Re: Change onership of database and all tables? (fwd) - Mailing list pgsql-general

If you use the following query:

select 'grant all on '||schemaname||'.'||tablename||' to NEWOWNER;'
from pg_tables
where schemaname in ('schema1', 'schema2', 'schema3', 'schemaN');

You will generate the appropriate scripts to grant ALL rights on tables
belonging to 'schema1', 'schema2', 'schema3', 'schemaN' to the user
NEWUSER.

Copy the resulting rows, and run them against the database. Simple, and
effective.

Hope that helps.

John Sidney-Woollett

Russ Schneider said:
>
> On Sun, 28 Dec 2003, Russ Schneider wrote:
>
>>
>> In 7.2, how would you change ownership of a database and all its tables
>> and sequences?
>>
>> Right now everything is owned by postgres and I want to change ownership
>> to a regualar user.
>
> Or if no one can answer the above question, what about a way to grant
> permissions on more than one table at a time?  Like GRANT ALL PRIVILEGES
> ON [ALL TABLES] TO [USER]?
>
> --
> [ Russ Schneider (a.k.a. Sugapablo)     ]
> [ http://www.sugapablo.com <--music     ]
> [ http://www.sugapablo.net <--personal  ]
> [ sugapablo@12jabber.com   <--jabber IM ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>