August 7, 2008 at 2:46 pm
Hi, long time lurker, first time poster. I'm trying to figure out a way to allow users to grant permissions to other only on objects that they create. Unfortunately, all objects get created and assigned to DBO as owner and we don't want to assign DBO permissions to the user. We've tried w/Grant for Execute and Alter Proceedure and Create Proceedure but are still not able to assign permissions to the object.
Any ideas?
August 7, 2008 at 3:05 pm
What have you already given them that allows them to Create PROC's in DBO?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 7, 2008 at 3:25 pm
Well, you could just have them create objects in their own Schemas. That is after all what Schemas are for.
The only way that I can see to do this in DBO without giving all user pretty hefty privileges would be to write a DDL trigger on CREATE [objects] to automatically assign ownership of the new object to the creating user, if the new object is in dbo.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply