Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Privileges problem: Solved.
All,
I didn't create a public synonym. Now I learn from my mistake.
ThankYou all, for your replies.
regards
Manasa.
>From: "Rachel Carmichael" <carmichr_at_hotmail.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Privileges problem.
>Date: Mon, 04 Dec 2000 12:45:57 -0800
>
>did you create a public synonym for set_role?
>
>otherwise have them execute it as <owner>.set_role
>
>
>>From: "Manasa Rao" <rao_manasa_at_hotmail.com>
>>Reply-To: ORACLE-L_at_fatcity.com
>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>>Subject: Privileges problem.
>>Date: Mon, 04 Dec 2000 10:00:46 -0800
>>
>>All,
>>
>>I have created some procedures and gave
>>grant execute on set_role to public;
>>which should let them execute the procedure. But the other user is not
>>able
>>to EXECUTE the procedure-set_role in my schema. They get the following
>>error
>>below.
>>
>>Appreciate any suggestions.
>>
>>Thanks
>>Radhika.
>>
>>12:54:54 SQL> execute set_role(1, NULL, NULL);
>>BEGIN set_role(1, NULL, NULL); END;
>>
>> *
>>ERROR at line 1:
>>ORA-06550: line 1, column 7:
>>PLS-00201: identifier 'SET_ROLE' must be declared
>>ORA-06550: line 1, column 7:
>>PL/SQL: Statement ignored
>>_____________________________________________________________________________________
>>Get more from the Web. FREE MSN Explorer download :
>>http://explorer.msn.com
>>
>>--
>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>--
>>Author: Manasa Rao
>> INET: rao_manasa_at_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_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).
>
>_____________________________________________________________________________________
>Get more from the Web. FREE MSN Explorer download :
>http://explorer.msn.com
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Rachel Carmichael
> INET: carmichr_at_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_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).
![]() |
![]() |