November 25, 2008 at 10:22 pm
Is there a way to create a quick interface like SSMS to manage SQL tasks for assigning roles?
November 25, 2008 at 11:40 pm
What would an SSMS Package be?
[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]
November 25, 2008 at 11:52 pm
Let me rephrase the question. I need to create an interface using which a user who does not directly work with SQL Server can create roles, logins, give rights to users etc. I was thinking it will be like simulating SSMS.
November 26, 2008 at 7:04 am
Well the functionality is not too hard, you could either use SMO, which is effectively the API for SSMS (actually, it is the management API for SQL Server, which SSMS uses) or you could write a series of stored procedures to give a relatively unprivileged and non-technical user the ability to do this.
What is a lot trickier is the user interface. There are no forms or graphical input capabilities built in to SQL Server (or SSMS), you have to either write client code or just use an existing interface like SSMS. You could just train your user to use the stored procs mentioned above, but this is not very visual.
The alternative would be to write your own GUI using C# or VB.net. It sounds like an interesting project/utility though, something that might be reusable for many other SQL Server customers.
[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]
November 26, 2008 at 7:58 am
Mnn, if you assign the users appropriate limited permissions
Won't they just use the same SSMS interface, just with less options?
They don't see everything a sysadmin would see
Beyond that, either write your own GUI or SMO/Power Shell (which I think it's only in SQL 2008)?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply