April 20, 2010 at 7:53 am
I've been told that once a user is connected to SQL Server using a trusted connection, they would then have access to all databases on that server.
I cannot find any information to either support or debunk that theory, but would like to find out more about it.
Can anyone provide me with resources/links that specifically address this?
Much appreciated,
Desiree
April 20, 2010 at 8:13 am
desiree.reagan (4/20/2010)
I've been told that once a user is connected to SQL Server using a trusted connection, they would then have access to all databases on that server.I cannot find any information to either support or debunk that theory, but would like to find out more about it.
Can anyone provide me with resources/links that specifically address this?
Much appreciated,
Desiree
This all depends on the permissions that the user has been granted on SQL Server. If they have been given sysadmin priviledges, then yes.
Database Roles: http://msdn.microsoft.com/en-us/library/ms189121.aspx
Fixed Server Roles: http://msdn.microsoft.com/en-us/library/ms175892.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply