GetDatabaseNames function

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dam54
Posts: 10
Joined: Thu 23 Jun 2011 19:26

GetDatabaseNames function

Post by dam54 » Wed 09 Jan 2013 14:32

Hello - can anyone help me with how this works. Specifically, I'm trying to figure out what determines which databases are returned. Does it go by the SQL login User's permissions? User's Roles? We have had different results and can't seem to determine what the criteria is. Thanks!

AndreyZ

Re: GetDatabaseNames function

Post by AndreyZ » Wed 09 Jan 2013 14:54

Hello,

The TMSConnection.GetDatabaseNames method returns all available databases on the server. If a user that is used to connect to the server does not have enough rights to work with a database, the name of this database will not be in the resulting list.

Post Reply