Good point Dave. I think many people don't take advantage of SQL Server's users and roles to the point that they could and miss out on some security potential. Though, practically speaking, for most average sites, it's probably easier for people to give dbo ownership of everything.
John Burns Certified Advanced ColdFusion MX Developer Wyle Laboratories, Inc. | Web Developer -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 18, 2005 3:04 PM To: CF-Talk Subject: RE: SQL Server User Problems > All objects "should" be owned by dbo. That is a best practice. If they > are owned by other owners, it can lead to bad things as well as > confusing code. I disagree with your assertion that using the dbo alias for ownership is a "best practice". There is nothing wrong with allowing specific logins to own objects, as long as you're aware that you're doing this. In fact, I'll go a step farther and say that if there's any best practice in this, it's to explicitly state table ownership in your queries. Of course, there are plenty of people who might disagree with me: http://www.sqlservercentral.com/columnists/awarren/worstpracticesobjects noto wnedbydbo.asp Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207075 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
