February 14, 2011 at 3:49 pm
Hi,
I just realized that I have logins that have access to some databases, where no users are created for these logins.
I hove no idea from where they can have access to the databases. Is there a way to find how they can access the database?
They are not assigned to any roles or schemas...
Any help will be appreciated.
February 14, 2011 at 3:56 pm
Are they a member of a server role such as sysadmin?
February 17, 2011 at 7:00 am
You can get closer to the resolution if you check this cool script out:
http://www.sqlservercentral.com/scripts/Administration/67567/
__________________________
Allzu viel ist ungesund...
February 17, 2011 at 8:19 am
Perhaps they are a member of an AD group, and that group has database permissions.
February 17, 2011 at 8:24 am
For an unknown reason the user was granted Admin on the local server :w00t:
Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply