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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
