June 2, 2008 at 6:02 am
Dear All,
Could anyone tell me how can i lock to my own datatbase that
no one can access ?
Pls tell me as soon as possible. I have to apply on my project.
Regards,
Sunil
June 2, 2008 at 6:19 am
Restricting access is not something you should do on a fly. Do the following -
1. Decide and Write down the various access levels required by the various users/groups
2. Talk with you business owners and agree upon the access levels
3. Test the security changes on a pilot server and ensure that everything is as expected
4. Go ahead and do the changes on the live server/database.
You can search and will get a lot of best practices on security. Once again, doing security changes is not something that you should decide over a minute and apply ASAP.
June 3, 2008 at 9:39 am
Sunil,
You should not be able to lock the DB, but could be able to restict for other users the DB.
Go to the DB property and Click on the Option Tab and select restrict Check box. SO only having DBO access can be able to use the DB.
MCP, MCTS (GDBA/EDA)
July 1, 2008 at 3:04 am
Hi all,
In addition to Sunil's question, I am curious how to set the DB security to prevent being restored to other SQL Server by using a new 'sa'?
I meant, within a SQL server (eg, PC1\myDB) I am able to control users from alter table, alter sp and so on and a strong 'sa' password is also created. Then, I login with a backup operator ID (who can only make backup and can't access elsewhere) to backup DB.
Under the same server, the backup operator is able to restore and his and others' rights are also bonded.
However, when I restored the backup DB to another server with a new 'sa' and the entire DB is just open for me to do whatever I want.
How to prevent this? I believe Sunil would like to know as well.
TIA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply