Why subscriber may see all other users MSSQL databases?

Created:

2016-11-16 12:40:50 UTC

Modified:

2016-12-21 18:57:31 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Why subscriber may see all other users MSSQL databases?

Symptoms

While opening a MSSQL database by webadmin, it shows all databases in ASP.NET Enterprise manager no matter which database owned by the database user.

Cause

Guest user is added to database permissions. Guest user allows database access to logins who do not have associated users inside SQL Server databases.

Resolution

  1. Login to MSSQL Server using MSSQL Server Management Studio

  2. Right click on database->properties->permissions

  3. Make sure that there is no Guest user or he does not have permissions to database

  4. If Guest user exists, revoke the access of access from user database with script:

    -- Specify database name in USE statement
    USE [<SpecifyDatabaseName>]
    GO

    REVOKE CONNECT TO [guest]
    GO
Have more questions? Submit a request
Please sign in to leave a comment.