Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g4RHHva21201 for ; Mon, 27 May 2002 13:17:57 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id CAA25160; Mon, 27 May 2002 02:15:19 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b71/bab) via UUCP id 0046C0B7; Mon, 27 May 2002 01:28:55 -0800 Message-ID: Date: Mon, 27 May 2002 01:28:55 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "novicedba" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "novicedba" Subject: Re: novice learns a new thing Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 71; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-MIME-Autoconverted: from 8bit to quoted-printable by newsfeed.cts.com id CAA25160 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by naude.co.za id g4RHHva21201 But the interesting point is that scott never granted the privileges on the object to test1 Coz I am a NoviceDBA Oracle Certifiable DBBS An obstacle is something you see when you take your eyes off the goal -- Anonymous ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" Sent: Monday, May 27, 2002 2:23 PM A quick look showed normal behaviour. You granted as the object owner select to test1 and scott than as test1 you tried describing a scott object that scott does not own but only has select rights on thus the error. after you created the synonym scott owned an object with that name (pointing to hlldew object) so the describe worked. jack "novicedba" l.com> cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) Sent by: Subject: novice learns a new thing root@fatcity.com 27-05-2002 10:28 Please respond to 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 ================================================================== De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. ===================================================================== The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. 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. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. =================================================================== -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: nlzanen1@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@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: novicedba INET: novicedba@hotmail.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@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).