Re: How to I get a list of databases?

Same permissions quandary, but EM uses the sp_databases system stored
procedure if I am not mistaken.

Dave Navarro wrote:
But don't you have to have permission to access
master.dbo.sysdatabases?

I am wondering because if I connect to my ISP's SQL server using
Enterprise Manager, EP will only show me the databases that I own or
have permission to access.

Since I don't have admin rights to their server, I'm wondering how EP
was able to deduce which databases I can access.

--Dave

In article <OYvBBwVzHHA.4928@xxxxxxxxxxxxxxxxxxxx>, reb01501
@NOyahoo.SPAMcom says...
Dave Navarro wrote:
How can I get a list of databases in an SQL server that I have
permissions for?

You can get a list of databases by querying the
master.dbo.sysdatabases table. Depending on the version of SQL
Server you are using, there are other ways as well.

Then, to determine which ones you have permissions for, I guess you
would need to loop through the list of names and attempt to open a
connection to each one in turn, catching the error if it fails.


I have used ADOX to get a list of tables in a database, but I can't
find any sample ADOX code for getting a list of databases on a
server that I can access.

That's because ADOX is geared to work with a single database at a
time: its top-level object is the Catalog, i.e., database.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Exchange Move Issues?
    ... I'm a bit confused on what permissions to assign for SBS, ... When you finish moving the databases, ... You can move the log files and database files to any folder that you want to ... Note Only assign permissions to the Server Operators group if the Exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: Open DB using OLE DB
    ... Can I get the list of databases available ... You can either use ADOX or use the ADO ... You don't need to keep a bunch of local server ... you'll have to add the user's domain account to ...
    (microsoft.public.vb.general.discussion)
  • Re: Move 10 DBs and provide dev access thru EM?
    ... but I tried this on a test server and the DBs ... Permissions should not have been lost if you simply detached and re-attached ... can I provide access to the databases for our developers through ...
    (microsoft.public.sqlserver.security)
  • Re: Lost User rights / permissions
    ... You might try running SQL Profiler and capturing some events in the Security Audit class to see if someone is "messing" with the permissions, ... > No databases have been restored when this happens. ... >>SQL Server FAQ, articles, code samples, interview ...
    (microsoft.public.sqlserver.security)
  • Re: Move 10 DBs and provide dev access thru EM?
    ... I know my procedure is correct as I did this on a test server this morning ... but I tried this on a test server and the DBs ... Permissions should not have been lost if you simply detached and re-attached ... roles in all databases or can I assign a single role and apply to all? ...
    (microsoft.public.sqlserver.security)