Postgres Pro
Downloads
Home   >   mailing lists

Re: Granting Privileges in Postgres - Mailing list pgsql-general

From John R Pierce
Subject Re: Granting Privileges in Postgres
Date
Msg-id 4E3F6E31.2070706@hogranch.com
Whole thread Raw
In response to Granting Privileges in Postgres  (Adarsh Sharma <adarsh.sharma@orkash.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Adarsh Sharma
Date:
Subject: Granting Privileges in Postgres
Next
From: - -
Date:
Subject: Re: Query with rightmost function does not use index