Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> A problem with user_users
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____________________________________Received on Wed Jun 02 1999 - 13:17:29 CDT
| _____ |
| (~._.~) |
|Email:petermag_at_singnet.com.sg _{ Y }_ |
|Phone:97813086(HP) ()_~~~_()|
|Pager:96047971 (_)-(_) |
|http://web.singnet.com.sg/~petermag/ |
|__________________________________________________|
![]() |
![]() |