RE: Privileges problem.

From: Dara Vaughn <dara.vaughn_at_wcom.com>
Date: Mon, 04 Dec 2000 12:42:44 -0600
Message-Id: <10700.123553@fatcity.com>

Manasa,

It is looking for the procedure set_role in the current schema, because you haven't qualified the name with the schema that owns it. If you do not wish to qualify the procedure with the owner's name everytime you want to use it, then create a public synonym for the procedure your_schema.set_role.

Dara Vaughn
Oracle DBA
Quality Software Engineering

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Manasa Rao Sent: Monday, December 04, 2000 12:01 PM To: Multiple recipients of list ORACLE-L Subject: Privileges problem.

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). Received on Mon Dec 04 2000 - 12:42:44 CST