Postgres Pro
Downloads
Home   >   mailing lists

Grant permission to all objects of user A to user B - Mailing list pgsql-sql

From kumar
Subject Grant permission to all objects of user A to user B
Date
Msg-id 017d01c422b7$0220cc80$7502a8c0@hdsc.com
Whole thread Raw
Responses Re: Grant permission to all objects of user A to user B  (Christoph Haller <ch@rodos.fzk.de>)
List pgsql-sql
Tree view
Dear Friends,
 
Postgres 7.3.2.
 
I have an database with owner USRA who owns about 300 objects (tables and functions). Now I want to give 'ALL' permission to all the objects of USRA to another database user USRB.
 
If I use the grant i need to type all the objects as comma separated, like the following
booktown=# GRANT ALL ON customers, books, editions, publishers
booktown-#           TO manager;
CHANGE
Is there any other way do it.
 
Thanks
Kumar

pgsql-sql by date:

Previous
From: sad
Date:
Subject: type conversions
Next
From: Richard Huxton
Date:
Subject: Re: [GENERAL] SQL script