Re: SQL server - won't enumerate unless user has access to all databases
This post has NOT been accepted by the mailing list yet.
Yes but errors out and get no databases after failure.
User is set up so that it cannot even connect to databases, but full admin on a couple...
Code must be getting database list from master table even though user can't see database
I am running MGOS 2.2.5703 and Maestro 188.8.131.5227 and I just tested gettting a list of databases (with a user who has only access to a single database) i get the following error (and no way to select any data store):
Failed to enumerate data stores. Reason: The remote server returned an error: (559) MgFdoException._:
An exception occurred in FDO component.
RDBMS: [Microsoft][ODBC SQL Server Driver][SQL Server]The server principal "xxx" is not able to access the database "yyy" under the current security context.