Hi, It is possible but this is database specific. Ex. In Oracle, run the following SQL command (after connecting as user "SYSTEM" to the db with the appropriate passowrd) select username from dba_users; The resultset will contain a list of all the users (I guess this is what you are after). The catch is that the SYSTEM is a DBA user and this user is generally not advised to login the system for application specific tasks, but surely this can be worked around by your DBA. Maybe you can speak to him! :-) Regards Nitin Goyal Webrizon eSolutions Pvt. Ltd., INDIA [EMAIL PROTECTED] There is no failure except in no longer trying. ----- Original Message ----- From: "Soubhratra Das" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 25, 2001 4:19 PM Subject: )FF-TOPIC:searching for all databases in a DBMS in the server Hi all Is it possible to display the names of all the databases present in a DBMS in server. Suppose the DBMS is oracle or SQL server.How to find which databases are present in these databases and show the database names on web page. TIA, soubhratra. _______________________________________________________________________________ Soubhratra Das Master of Computer Applications. Sun Certified Java Professional. _______________________________________________________________________________ Where there is a will there is a way. _______________________________________________________________________________ ____________________________________________________________ Sent via ocsemail from IASRI Intranet System intranet ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
