Weird happenings inside the package

Firstly because procedures execute under the owner who owns them unless you use an 8i option to make them run in the context of the user who called them.
Secondly, executing a procedure removes all roles and associated permissions but leaves the explicit grants, so if you have grants supplied via a role, then these will not be in force when the procedure executes.
Thirdly, when you run the select in sqlplus, the permissions granted through roles are considered :o)

HTH, but if not, see the Oracl faq for more details : http://www.jlcomp.demon.co.uk/faq/plsql_privs.html

Norman.

Norman Dunbar		EMail:	NDunbar_at_LynxFinancialSystems.co.uk
Database/Unix administrator	Phone:	0113 289 6265
Lynx Financial Systems Ltd.	Fax:	0113 201 7265
			URL:	http://www.LynxFinancialSystems.com


------------------------------------------------------------------------

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

From: Peasant [mailto:1_at_a.b]
Posted At: Thursday, August 16, 2001 10:05 AM Posted To: server
Conversation: Weird happenings inside the package Subject: Weird happenings inside the package

<SNIP>

If I execute the package using the login that created it (SYSTEM) then it returns the correct value. If, however, I connect as another user (that does have select rights on ALL_TABLES) the procedure returns zero, but running the select statement that sets h_count returns the correct value. Why ?

--

Peasant Received on Thu Aug 16 2001 - 05:42:28 CDT