how to prevent db deletion - SQL Server Forums

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

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

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"

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

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

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

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

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. :)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources