RE: [SQLDownUnder] Master database & oops part 2

[Yeniceri, Gurkan]

I am also totally agreed with this.

 

It is a must have for the developers who are accessing to the databases like me.

Regards,
 
Gurkan Yeniceri
Analyst Developer
0401 714 153
+61 (0) 2 6216 4583
 
 
 

---

From: SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx [mailto:SQLDownUnderList@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Greg Low
Sent: Thursday, March 03, 2005 8:38 PM
To: sqldownunder@xxxxxxxxxxxxxxxxxxxxxx
Subject: [SQLDownUnder] Master database & oops part 2

 

I was in an Ascend class with Bob Beachemin yesterday and saw yet another
person run a script in the master database when they meant to be elsewhere.
I realised you could now basically fix that with a DDL trigger in SQL Server
2005 (blogged about it at http://msmvps.com/greglow).

However, it struck me that I'd really like a server option that says
"Protect master schema" or something (as an advanced option), rather than
having to even set up a trigger. I mentioned it to one of the dev guys and
he seemed lukewarm yet every single person I've mentioned it to so far says
"oh yes yes please". I got Dave Lean to post a request on it last night but
I wanted to get your opinions.

Would that be useful? Can you see any problems?

I'm just figuring that 99.9% of DDL mods to master are in error and should
be prevented by default.

Thanks,

Greg

****************************************************************
IMPORTANT

The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material. Any review, re-transmission, disclosure dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties. If you have received this e-mail in error please notify the Privacy Hotline of the Australian Taxation Office, telephone 13 28 69 and delete all copies of this transmission together with any attachments.
****************************************************************
to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net to unsubscribe to this list, please send a message back to the list with 'unsubscribe' as the subject. Powered by mailenable.com - List managed by http://www.readify.net