N/APosted 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.
How can I set a password for any database in SQL Server
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.
Close MyNew App.mdb
Click Open Database Button
Select MyNewApp.mdb. click the arrow next to the Open button.
Choose Open Exclusive.
Choose Tools, Security, Set Database Password
In the Password and Verify text boxes, type dbpassword.
Close the Database.
Type dbpassword, and click OK.
Hope this steps will help you secure our database.