Re: [SQL] regarding grant option

From: "AKHILESH GUPTA" <akhilesh(dot)davim(at)gmail(dot)com>
To: "AKHILESH GUPTA" <akhilesh(dot)davim(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] regarding grant option
Date: 2006-03-01 14:28:04
Message-ID: ad39daf90603010628q5e303d83g4cf419606d8fa726@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

thank you very much sir for your valuable suggestion,
but i am talking about direct database query...........!

On 3/1/06, Alvaro Herrera <alvherre(at)commandprompt(dot)com> 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/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

--
Thanks & Regards,
Akhilesh
DAV Institute of Management
Faridabad(Haryana)
GSM:-(+919891606064)
(+911744293789)

"FAILURES CAN BE FORGIVEN BUT AIMING LOW IS A CRIME"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2006-03-01 15:00:16 Re: [SQL] regarding grant option
Previous Message Michael Fuhr 2006-03-01 14:08:23 Re: Triggers question

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2006-03-01 14:30:54 Re: Help with trigger that updates a row prior to a potentially
Previous Message Simon Kinsella 2006-03-01 14:19:43 Re: Help with trigger that updates a row prior to a potentially aborted deletion?