May 1, 2008 at 10:13 am
I'm looking for a way to allow a login or role to create/drop indexes or a specific index if possible...
So far my efforts have been in vain.
Specific index would be best but we can live with any index cause right now they have the full ddl access 🙁
Thanks,
Nam
May 1, 2008 at 10:54 am
As far as I know, it is a mission impossible.
May 1, 2008 at 12:42 pm
That's the impression I got thanks for the confirmation.
May 1, 2008 at 8:24 pm
I think that you would need to write a stored procedure or a CLR to do it on their behalf. Very tricky to give them all of the abilities they need and still be secure.
[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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply