SQL Limit User

Handian Sudianto 4,431 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,274 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 34,996 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