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

> > 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 se

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

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 th