> > Dear Friends, > > Postgres 7.3.2. > > I have an database with owner USRA who owns about 300 objects (tables and f= > unctions). Now I want to give 'ALL' permission to all the objects of USRA t= > o another database user USRB. > > If I use the grant i need to type all the objects as comma separated, like = > the following > booktown=3D# GRANT ALL ON customers, books, editions, publishers > booktown-# TO manager; > CHANGE > Is there any other way do it.ThanksKumar > > If you're using schemas you can grant the whole schema to the new user. If not, the only alternative I know about is extract the table/function names via \dt / \df commands within psql and use a script to grant the privileges.
Regards, Christoph ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
