Re: How to GRANT...WITH GRANT OPTION?

From: Joshua Leshan <leshan(at)ugsolutions(dot)com>
To: R D <mrk279(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to GRANT...WITH GRANT OPTION?
Date: 2000-05-16 18:19:35
Message-ID: Pine.LNX.3.96.1000516131507.21412M-100000@diner.ug.eds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi, did you figure this out? I'm not quite sure what you are asking,
but . . .

leshan=> \h grant
Command: grant
Description: grant access control to a user or group
Syntax:
GRANT privilege1, ...privilegeN ON rel1, ...relN TO
[PUBLIC|GROUP group|username]
privilege is ALL|SELECT|INSERT|UPDATE|DELETE|RULE

leshan=> grant select on all_users to public;
CHANGE
leshan=>

Hope that helps.
Jd

On Tue, 16 May 2000, R D wrote:

> Hi, how can I grant privileges with grant option since
> PostgreSQL does not support statement:
> GRANT .... WITH GRANT OPTION;
> if this is done by default then how can I grant
> privileges without grant option?
>
> Rumen
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vladimir V. Zolotych 2000-05-18 07:49:36 non functional update
Previous Message R D 2000-05-16 14:02:02 How to GRANT...WITH GRANT OPTION?