Oracle-L: RE: accessing user_users via a procedure in SYS

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Fri, 30 Aug 2002 14:28:19 -0800
Message-ID: <F001.004C4A2A.20020830142819@fatcity.com>

What is wrong in: select user from dual;

Waleed

-----Original Message-----
Sent: Friday, August 30, 2002 3:09 PM
To: Multiple recipients of list ORACLE-L

Hi,

I am trying to put together a package that uses the AUTHID current_user directive to decide whether to let people kill a session or not, and I ran into a problem.

One procedure will run as SYS, but I need to double-check the requester's username to ensure he/she isn't trying to kill their neighbour's session.

To do that I build a function that runs with the AUTHID current_user directive and tries to select username from user_users. Hopefully it will be able to pass back the username to the parent proc.

When I try to run a procedure that does a select against user_users using that directive, I get an error:
PLS-00357: Table,View Or Sequence reference 'USER_USERS' not allowed in this context

I found tech note 162489.1, according to that, shouldn't user_users work as well?

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------