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