Share via

SQL Limit User

Handian Sudianto 5,001 Reputation points
2023-12-04T03:44:27.7066667+00:00

Hello,

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,894 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 36,751 Reputation points
    2023-12-04T05:56:16.8166667+00:00

    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

    Regards，

    Zoe Hui

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

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.