SQL Limit User

Handian Sudianto 4,431 Reputation points


I have 2 test database (test and test2) and each database have separate account. if i login using test2 account i'm able to see the test2 databaseUser's image

If i try to navigate to test database i got an error an this is what i want. Now how we can make test2 user only can see test2db? So the user prohibit viewing other db where the suer don't have an access.User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,274 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,996 Reputation points

    Hi @Handian Sudianto,

    Updated answer:

    You may follow this thread that given the workaround.

    I followed the steps which worked for me.

    User's image


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

0 additional answers

Sort by: Most helpful