Ther is Nothing Strange in this. If you see the Object was owned By hlledw.
You granted the Rights to Both Scott and Test but there was not Object named edw_% in these schemas. Then u Tries to describe the Object thru hlledw and that worked but when u tried to acces it thru scott it did not work because as mentioned above there was no schema object so u got an error. Now U wen into scott and created a Synonym for the hlledw object and hen there was a Object named edw% in scott and hence when u again accesed it it redirected the request to the hlledw schema and u got the result. Hope u got it. Now my $0.02 Cents I feel u should pick up a good book like Oracle 8i Complete Reference and read it from back to back. Also complement that book with the concepts manual and the books by thomas kyte -- Beginning Oracle Programming and Expert One-On-One Oracle. HTH Best Regards, Ganesh R Tel : +971 (4) 397 3337 Ext 420 Fax : +971 (4) 397 6262 HP : +971 (50) 745 6019 ============================================ Live to learn... forget... and learn again. ============================================ -----Original Message----- Sent: Monday, May 27, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Hi all, I noticed something strange. Logically it makes sense but nevertheless strange. I don't know how to pur it in words. So seniors please help =========================================================== SQL> conn hlledw/hlledw@orcl9i Connected. SQL> grant select on edw_week_lvl to scott; Grant succeeded. SQL> grant select on edw_week_lvl to test1; Grant succeeded. SQL> conn scott/tiger@orcl9i Connected. SQL> desc hlledw.edw_week_lvl Name Null? Type ------------------------------- -------- ---- ID NOT NULL NUMBER(5) CODE NOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATE NOT NULL DATE TIMESPAN NOT NULL NUMBER(3) SQL> conn test1/test1@orcl9i Connected. SQL> desc hlledw.edw_week_lvl Name Null? Type ------------------------------- -------- ---- ID NOT NULL NUMBER(5) CODE NOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATE NOT NULL DATE TIMESPAN NOT NULL NUMBER(3) SQL> desc scott.edw_week_lvl ERROR: ORA-04043: object scott.edw_week_lvl does not exist SQL> conn scott/tiger@orcl9i Connected. SQL> create synonym edw_week_lvl for hlledw.edw_week_lvl; Synonym created. SQL> desc edw_week_lvl Name Null? Type ------------------------------- -------- ---- ID NOT NULL NUMBER(5) CODE NOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATE NOT NULL DATE TIMESPAN NOT NULL NUMBER(3) SQL> conn test1/test1@orcl9i Connected. SQL> desc hlledw.edw_week_lvl Name Null? Type ------------------------------- -------- ---- ID NOT NULL NUMBER(5) CODE NOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATE NOT NULL DATE TIMESPAN NOT NULL NUMBER(3) SQL> desc scott.edw_week_lvl Name Null? Type ------------------------------- -------- ---- ID NOT NULL NUMBER(5) CODE NOT NULL VARCHAR2(16) DSC NOT NULL VARCHAR2(40) END_DATE NOT NULL DATE TIMESPAN NOT NULL NUMBER(3) SQL> ================================================================= This is all strange to me Coz I am a novice DBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ganesh Raja INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
