Post reply

Anonymous user.

  • April 14, 2011 at 8:12 pm

    #249039

    I have SQL 2005 database. It has 200 db users. How can I ensure that there is no anonymous user in it.

    Is there any role I can create to check it.

    Any help will be appreciable.

  • April 14, 2011 at 8:23 pm

    #1311919

    Not to sure what you mean by anonymous user. For anyone to connect to your SQL instance they first have to have a login active, then a user account to a database mapped to that login.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply