AKHILESH GUPTA wrote: > thank you very much sir for your valuable suggestion, > but i am talking about direct database query...........! There is none that can help you here, short of making a function in PL/pgSQL or other language ... > On 3/1/06, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> wrote: > > > > AKHILESH GUPTA wrote: > > > > > here i have to grant permissions to that user individually for each and > > > every table by using: > > > :->> grant ALL ON <tab_name> to <user_name>; > > > GRANT > > > and all the permissions are granted to that user for that particular > > table. > > > > Yes. If you are annoyed by having to type too many commands, you can > > write a little shell script to do it for you. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
