[SQL] Grant permission to all objects of user A to user B

kumar Wed, 14 Apr 2004 23:58:22 -0700

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

[SQL] Grant permission to all objects of user A to user B

Reply via email to