How can I set a password for any database in SQL Server

Asked By imtiazbzu 10 points N/A Posted on - 08/12/2011

I am using SQL server in my office, it contains really sensitive databases, I have made a lot of securities in server like secured login to windows and its secured access on the LAN, but even then I want to set passwords in every database so that no one can access these highly secured databases except me.

• Status: Open
• Question Views: 901
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Michael Moroe 5 points N/A #113158

How can I set a password for any database in SQL Server

Hello Imtiazbzu,

Steps to create password in Database are given below and this will ensure that your database is safe. This will protect from adding, deleting, editing stored data. This also will not compromise the structure of your program because even 1 file is missing in your database, this will affect the whole software program.

Follow the steps to secure your database.

1. Close MyNew App.mdb
2. Click Open Database Button
3. Select MyNewApp.mdb. click the arrow next to the Open button.
4. Choose Open Exclusive.
5. Choose Tools, Security, Set Database Password
6. In the Password and Verify text boxes, type dbpassword.
7. Click Ok
8. Close the Database.
9. Open MyNewApp.mdb
10. Type dbpassword, and click OK.

 Hope this steps will help you secure our database.

About Michael Moroe

Questions
0

Answers
5

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/12/2011
• Question Category: MS SQL Server