There is a distinction between 'create synonym' and
'create public synonym' privileges. Have you granted
the latter?
Marty
I apolagise for my speling.
> Simple question (I think)
>
> I'm not a PL/SQL expert and am trying to write a
> little PL/SQL that reads
> from user tables and creates public synonyms for
> whatever it finds.
>
> I keep hitting the insufficient privilege error even
> though I granted
> create synonym privilege directly.
>
> What other privilege do I need to grant directly?
>
>
>
> Jack
>
>
> De informatie verzonden met dit E-mail bericht is
> uitsluitend bestemd voor
> de geadresseerde. Gebruik van deze informatie door
> anderen dan de
> geadresseerde is verboden. Openbaarmaking,
> vermenigvuldiging, verspreiding
> en/of verstrekking van deze informatie aan derden is
> niet toegestaan.
> Ernst & Young staat niet in voor de juiste en
> volledige overbrenging van de
> inhoud van een verzonden E-mail, noch voor tijdige
> ontvangst daarvan.
>
> The information contained in this communication is
> confidential and may be
> legally privileged. It is intended solely for the
> use of the individual or
> entity to whom it is addressed and others authorised
> to receive it. If you
> are not the intended recipient you are hereby
> notified that any disclosure,
> copying, distribution or taking any action in
> reliance on the contents of
> this information is strictly prohibited and may be
> unlawful. Ernst &
> Young is neither liable for the proper and complete
> transmission of the
> information contained in this communication nor for
> any delay in its
> receipt.
>
>
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: nlzanen1_at_ey.nl
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Received on Tue Oct 31 2000 - 12:34:22 CST
