Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are also bonded. However, when I restored that backup database to another SQL Server with a new ‘sa’, the entire database becomes entirely open. How can set my database security to prevent this from occurring?
July 2, 2008 5:21 PM
July 3, 2008 3:19 AM