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
 General SQL Server Forums
 New to SQL Server Programming
 how to prevent db deletion

Author  Topic 

Fozzy
Starting Member

3 Posts

Posted - 2006-11-22 : 07:11:58
Hi

I want to try and protect myself from my own stupidity. I have a number of sql databases, but one is LIVE. It is easy to drop tables but I want to set something (e.g. a password) which will help prevent me from dropping tables on the live database.

Any help/direction here would be appreciated.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-22 : 07:12:47
Are you using SQL 2000 or SQL 2005?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Fozzy
Starting Member

3 Posts

Posted - 2006-11-22 : 07:15:54
Hi, What I have under help is : -

Microsoft SQL Enterprise Manager

Microsoft Corporation

Version: 8.0
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-22 : 07:22:33
Are you using sa login?

Create another user with limited permissions to LIVE database and login using that user name.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-11-22 : 07:24:16
I asked for which version of the database engine you use, not the client tool version.
Yes, you are using Enterprise Manager. And I guess you are using SQL Server 2000.

Then the only reasonable solution is that you DO NOT LOGIN as SA or with any other administrator role!



Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-11-22 : 07:26:08
Take frequent backups. Implement a mature software process.

Jay White
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-11-22 : 07:53:09
You could run 2 instances on that machine. Production databases on one, Test databases on the other.

But really LIVE stuff should be on a separate server to TEST/QA/DEV stuff. (Although we have "Staging-Test" on Production Servers so that we can properly evaluate performance in real-world conditions, so I'm not walking-my-talk)

Kristen
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2006-11-22 : 08:44:09
and let me guess...the "application" uses sa to login



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2006-11-22 : 09:59:17
I'm sure after you accidentally DROP a few live tables that will give you the increased mental reminder needed to prevent you doing it again. The churny-stomach feeling should do it all by itself.

-------
Moo. :)
Go to Top of Page
   

- Advertisement -