SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 how to prevent db deletion		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Fozzy
Starting Member

3 Posts
Posted - 11/22/2006 :  07:11:58  Show Profile  Reply with Quote
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

Sweden
29138 Posts
Posted - 11/22/2006 :  07:12:47  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Are you using SQL 2000 or SQL 2005?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

Fozzy
Starting Member

3 Posts
Posted - 11/22/2006 :  07:15:54  Show Profile  Reply with Quote
Hi, What I have under help is : -

Microsoft SQL Enterprise Manager

Microsoft Corporation

Version: 8.0
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts
Posted - 11/22/2006 :  07:22:33  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
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

Sweden
29138 Posts
Posted - 11/22/2006 :  07:24:16  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Edited by - SwePeso on 11/22/2006 07:24:36
Go to Top of Page

Page47
Flowing Fount of Yak Knowledge

USA
2878 Posts
Posted - 11/22/2006 :  07:26:08  Show Profile  Reply with Quote
Take frequent backups. Implement a mature software process.

Jay White
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 11/22/2006 :  07:53:09  Show Profile  Reply with Quote
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 - 11/22/2006 :  08:44:09  Show Profile  Reply with Quote
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

United Kingdom
1870 Posts
Posted - 11/22/2006 :  09:59:17  Show Profile  Visit mr_mist's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000