Post reply

Unauthorise user able to connect to a database

  • February 14, 2011 at 3:49 pm

    #246691

    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

    #1286784

    Are they a member of a server role such as sysadmin?

  • February 17, 2011 at 7:00 am

    #1288201

    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

    #1288259

    Perhaps they are a member of an AD group, and that group has database permissions.

  • February 17, 2011 at 8:24 am

    #1288265

    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