Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> A problem with user_users

A problem with user_users

From: Peter Teoh <petermag_at_singnet.com.sg>
Date: Thu, 03 Jun 1999 02:17:29 +0800
Message-ID: <37557539.AA6903C7@singnet.com.sg>


I used TS (a user-created schema) to create a stored procedures, which subsequently display user_users table. It shows TS as the user, this is correct.

Then I grant the execute privileges to another schema. Sqlplus as that user, and then call the same stored procedures, as TS.stored_procedure, again I display user_users table, which also shows TS as the user, even though I am now connected as another user.

WHY? My problem is:

HOW DO YOU DISPLAY THE USER CONNECTION INFORMATION (NORMALLY PROVIDED BY USER_USERS) WHILE RUNNING INSIDE A STORED PROCEDURE NAMESPACE? My conjecture is:

Since the stored procedure is created by TS, theefore it is nessary that any other schema calling this stored procedure to executa it must run the same stored procedure as TS user as well, ie, even though you are not connected as TS user, execution of any stored procedures in TS schema automatically means that a TS session will be created to run the stored procedure?

--

      \\\|///          Peter Teoh
    \\  - -  //        Oracle Certified Professional
     (  @ @  )
__oOOo-(_)-oOOo____________________________________

| _____ |
| (~._.~) |
|Email:petermag_at_singnet.com.sg _{ Y }_ |
|Phone:97813086(HP) ()_~~~_()|
|Pager:96047971 (_)-(_) |
|http://web.singnet.com.sg/~petermag/ |
|__________________________________________________|
Received on Wed Jun 02 1999 - 13:17:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US