OraFAQ Forum: Forms » Database Users LOV

Home » Developer & Programmer » Forms » Database Users LOV

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Users LOV [message #196118]

Wed, 04 October 2006 03:26

qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan

Member

Hi EveryOne,
I want to populate all the database users in an lov.
How can I get the list of database users? What query will be used to accomplish this.
Here database users means scott,system, sysdba etc etc...

Waiting For your Response.
Thanks
Regards
Qadeer Ahmed

Report message to a moderator

Re: Database Users LOV [message #196132 is a reply to message #196118]

Wed, 04 October 2006 04:53

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Check out the ALL_USERS table.

MHE

Report message to a moderator

Re: Database Users LOV [message #196392 is a reply to message #196118]

Thu, 05 October 2006 03:41

shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan

Member

hi

use the following query to papulate the database user into the
LOV

select user_name from all_users;

i hope it will work.

regards

Muhammad Shahid Mughal

Report message to a moderator