Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] which privilege for "create public synonym"?

Re: [Q] which privilege for "create public synonym"?

From: <peter.kallweit_at_vector-consulting.de>
Date: Tue, 03 Dec 2002 08:14:24 +0100
Message-ID: <3DEC59D0.902F02FA@vector-consulting.de>


Hi aaa,

(btw. - nice name)

aaa schrieb:
>
> I tried to "grant create public synonym to user1" and failed. If I "grant
> create synonym to user1", it grant "private" synonym. Can anyone tell me which
> privilege for "create public synonym"?
>

your command "grant create public synonym to user1" was ok. But you must have for yourself the "create public synonym with admin option"-grant.

Hth.
Peter Received on Tue Dec 03 2002 - 01:14:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US