RE: Privileges problem.

From: William Rogge <William_Rogge_at_voltek.com>
Date: Mon, 4 Dec 2000 16:16:15 -0500
Message-Id: <10700.123580@fatcity.com>

There is nothing wrong with the permissions. The issue is in the referencing of the procedure. Since it is not in the other users schema, they must fully qualify the procedure name.

ex.) Scott creates a procedure called DO_IT. He can execute it directly. He grants access for others to execute it. The others must reference SCOTT.DO_IT or oracle will not be able to locate the procedure. We use public aliases so the user does not need to know the schema that the item is in.

create public synonym do_it for scott.doit; Then the users simply reference 'do_it' and oracle figures out which schema it is in.

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

From:	Manasa Rao [SMTP:rao_manasa_at_hotmail.com]
Sent:	Monday, December 04, 2000 1: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 - 15:16:15 CST