Re: A problem with user_users

In SQL*Plus, you can use 'show user'

stj

Nicolas Bronke wrote:

> Peter Teoh <petermag_at_singnet.com.sg> schrieb in im Newsbeitrag:
> 37557539.AA6903C7_at_singnet.com.sg...>
> > HOW DO YOU DISPLAY THE USER CONNECTION INFORMATION (NORMALLY PROVIDED BY
> > USER_USERS) WHILE RUNNING INSIDE A STORED PROCEDURE NAMESPACE?
> >
> I did not check your procedure and whether you are right. If you are right,
> try that
> select * from all_users where username=user
>
> kind regards
> Nicolas
Received on Tue Jun 08 1999 - 12:59:35 CDT