| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Public synonym not really there
Hi!
SYS user normally has SELECT ANY TABLE privilege, so this shouldn't be the problem.
As I see from the sql, you have issued two identical drop public synonym and two identical create public synonym commands, but they behave differently. Did you just issue two identical create public synonym commands in a row, from which the first attempt returned one and immediately the next attempt other error message?
If that's the case, we would probably be dealing with a bug (or someone is playing around with your public synonyms simultaneously)
Tanel.
"DA Morgan" <damorgan_at_exesolutions.com> wrote in message
news:3E569628.117F63BB_at_exesolutions.com...
> vlad wrote:
>
> > I would be very intered to know if anybody can explain the behavior
below. I
> > have Oracle 9.2 installed on my single-user home machine. A while ago I
had
> > created a public synonym called "countries" on "hr"."countries". Now, I
> > logged in as SYS and tried to do SELECT * FROM countries. Well, you can
see
> > below what happened.
> >
> > SQL> SELECT * FROM all_synonyms WHERE synonym_name LIKE '%COUNT%';
> >
> > OWNER SYNONYM_NAME
TABLE_OWNER
> > TABLE_NAME DB_LINK
>
> ------------------------------ ------------------------------ ------------
--Received on Sun Feb 23 2003 - 12:06:46 CST
>
> ---------------- ------------------------------ --------------------------
--
>
> --------------------------------------------------------------------------
--
> > ------------------------
> > PUBLIC DEFERRCOUNT SYS
> > DEFERRCOUNT
> > OE COUNTRIES HR
> > COUNTRIES
> > PUBLIC COUNTRIES HR
> > COUNTRIES
> >
> > SQL> SELECT * FROM countries;
> >
> > SQL> SELECT * FROM COUNTRIES;
> > SELECT * FROM COUNTRIES
> > *
> > ERROR at line 1:
> > ORA-00942: table or view does not exist
> >
> > SQL> drop public synonym countries;
> > drop public synonym countries
> > *
> > ERROR at line 1:
> > ORA-01432: public synonym to be dropped does not exist
> >
> > SQL> create public synonym countries for hr.countries;
> > create public synonym countries for hr.countries
> > *
> > ERROR at line 1:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-00001: unique constraint (SYS.I_OBJ2) violated
> >
> > SQL> create public synonym countries for hr.countries;
> > create public synonym countries for hr.countries
> > *
> > ERROR at line 1:
> > ORA-00955: name is already used by an existing object
> >
> > SQL> drop public synonym countries;
> >
> > Synonym dropped.
> >
> > SQL> create public synonym countries for hr.countries;
> >
> > Synonym created.
> >
> > SQL> SELECT * FROM countries;
> >
> > CO COUNTRY_NAME REGION_ID
> > -- ---------------------------------------- ----------
> > AR Argentina1 2
> > AU Australia 3
> > BE Belgia 1
> > BR Brazil 2
> > BU Bulgaria 1
> > CA Canada 2
> > CH Switzerland 1
> > CN China 3
> > DE Germany 1
> > DK Denmark 1
> > EG Egypt 4
> >
> > CO COUNTRY_NAME REGION_ID
> > -- ---------------------------------------- ----------
> > FR France 1
> > HK HongKong 3
> > IL Israel 4
> > IN India 3
> > IT Italy 1
> > JP Japan 3
> > KW Kuwait 4
> > MX Mexico 2
> > NG Nigeria 4
> > NL Netherlands 1
> > SG Singapore 3
> >
> > CO COUNTRY_NAME REGION_ID
> > -- ---------------------------------------- ----------
> > UK United Kingdom 1
> > US United States of America 2
> > ZM Zambia 4
> > ZW Zimbabwe 4
> >
> > 26 rows selected.
> >
> > SQL>
>
> Synonyms are not grants. Did you consider
>
> GRANT SELECT ON <table_name> TO sys?
>
> Daniel Morgan
>
 |
 |