Home » Developer & Programmer » Forms » Database Users LOV
icon5.gif  Database Users LOV [message #196118] Wed, 04 October 2006 03:26 Go to next message
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
Re: Database Users LOV [message #196132 is a reply to message #196118] Wed, 04 October 2006 04:53 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Check out the ALL_USERS table.

MHE
Re: Database Users LOV [message #196392 is a reply to message #196118] Thu, 05 October 2006 03:41 Go to previous messageGo to next message
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
Re: Database Users LOV [message #196395 is a reply to message #196392] Thu, 05 October 2006 03:45 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Thumbs Up So you have checked out the all_users table, Muhammad? That was indeed the point Wink

MHE

[Updated on: Thu, 05 October 2006 03:45]

Report message to a moderator

Re: Database Users LOV [message #198124 is a reply to message #196395] Sun, 15 October 2006 09:27 Go to previous message
qadeerahmed
Messages: 63
Registered: July 2006
Location: Pakistan
Member
ThankYou All !!
Previous Topic: Call report from a form - hits Invalid parameter Error
Next Topic: List Item
Goto Forum:
  


Current Time: Sat Dec 03 05:55:51 CST 2016

Total time taken to generate the page: 0.14737 seconds