Protect SQL Server database

Question

Protect SQL Server database

Navigation

#1 by (5 votes)
#2 by (3 votes)

2

I have 2 SQL Server databases in my SQL Server Management Studio.

I would like to put a password in one of them, making it impossible to access it, is it possible?

sql sql-server sql-server-2008

asked by anonymous 04.05.2017 / 21:26

2 answers

Set default SQL Server column value How can I test method with void return using JUnit?

score 5 · Answer 1

In the database itself it is not possible. What you can do is change which users have access to the database, remember that the master user (the one defined in the database installation, usually named sa ) will always have access to all banks.

To change users who have access to database , just expand Security and then Users ).

score 3 · Answer 2

You should open Object Explorer do Sql , expand Server, Security -> Logins , there you can add a user, and in User Mapping check the databases you want to allow.

To allow Sql Authentication , right click on the server, at Security check Sql Server and Windows Authentication Mode .