0

I have SQL Server 2017 instance with many databases, as an example, I have a database on this instant called DB_A, and I want to create a SQL Server user account to log in to this database (I will take the user name as User_A).

When I log in to an instance using this User_A account, it should only see DB_A - the user should not see other databases on this instance (hide other databases from User_A account).

I know the method to do this:

  • User_A set as an owner in this DB_A
  • Tick 'deny View all databases' in Public role

The issue is doing this user can have full control of this database but I want to give only table access to these users.

Specially I want to block access to the Programmability subfolder

Can anyone help me with this?

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.