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

Asked By 10 points N/A Posted on -

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.

Answered By 0 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.

Login/Register to Answer

Related Questions