Re: Granting Privileges in Postgres

On 08/07/11 9:58 PM, Adarsh Sharma wrote:
> Dear all,
>
> Today I researched on giving privileges in Postgres databases. I have
> 4 databases and near about 150 tables, 50-60 sequences and also some
> views in it.
>
> I want to give privileges to a new user in all these objects. I
> created a function for that but don't know how to give privileges on
> all objects all at once.

GRANT ALL ON ALL TABLES IN SCHEMA schema_name TO rolename;

this ON ALL TABLE IN SCHEMA option is new in 9.0



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast