Home > IT Answers > Security > Securing a SQL Server 2008 database
SQL Server Ask the Experts
2,585 pts.
 Securing a SQL Server 2008 database
Database security, SQL Server 2000, SQL Server database, SQL Server security
I am on SQL Server 2000, and to secure my database, I want the user to be prompted for a user ID and password before the database is expanded. How might I do this?

Software/Hardware used:
ASKED: November 4, 2008  5:54 PM
UPDATED: November 5, 2008  7:52 AM
RELATED QUESTIONS
Answer Wiki:
There is no way to do this unless you were to write a custom database management tool. Once the user has connected to the SQL Server what ever rights they have are what they have. If you do not wish a user to have access to a database within the SQL Serer you will need to revoke the users rights to the database. Anyone who is a member of the sysadmin fixed server role can not have these rights removed as they have full access to all databases within the SQL Server.
Last Wiki Answer Submitted:  November 5, 2008  7:52 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _