Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: novice learns a new thing
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> 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_at_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_at_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_at_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_at_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: ganesh_at_gtfs-gulf.com 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 Mon May 27 2002 - 04:23:35 CDT
![]() |
![]() |