| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Privileges problem.
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).
 |
 |