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: Public Synonyms

Re: Public Synonyms

From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Mon, 26 May 2003 12:10:44 GMT
Message-ID: <8vnAa.728305$OV.671802@rwcrnsc54>


Don't make them public. Look in the documentation.(like remove the word public)
Jim

-- 
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family.  Remove the negative part, keep the minus sign.  You can figure
it out.
"Martin Doering" <doeringm_at_gmx.de> wrote in message
news:ivh3dvcv9shbvcdvaf5de64l54dui5flfn_at_4ax.com...

> Hi!
>
> We have several bigger schemas in our database and the public synonyms
> of them tend to get in conflict with each others.
>
> Is there a possiblity to make synonyms not public, but make some kind
> of synonym-groups or such in the same way, as I can grant table-access
> to roles? Some kind of profiles or such?
>
> We have mostly Oracle 8.1.7.4
>
> --
> Thanks in advance, Martin
Received on Mon May 26 2003 - 07:10:44 CDT

Original text of this message

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