Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Password protecting a database

Author  Topic  Smogerp Starting Member 1 Post Posted - 2000-10-18 : 08:16:35 Currently due to space we moved our development environment over to the same server as our training and production environment is on. My question is there a way that I can protect updates through the back door with a password? My concerns is that I have a lot better chance at overwritting data or deleting data in production and thinking I am in development. I know that all I need to do is be more cautious. I want to make sure. With this security it would be set up for the developers only. The database is tied to an online application that is used daily by the entire corporation. So I don't want to have the general user community to have to deal with a password everytime they log in. Our current security utilizes NT Authenication. Any information will greatly be appreciated. Thank! Phill Phill