InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 15:34:23 GMT20http://www.sqlservercentral.com/Forums/Topic608850-149-1.aspxMnn, if you assign the users appropriate limited permissionsWon't they just use the same SSMS interface, just with less options?They don't see everything a sysadmin would seeBeyond that, either write your own GUI or SMO/Power Shell (which I think it's only in SQL 2008)?Wed, 26 Nov 2008 07:58:11 GMTJerry Hunghttp://www.sqlservercentral.com/Forums/Topic608850-149-1.aspxWell 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.Wed, 26 Nov 2008 07:04:11 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic608850-149-1.aspxLet 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.Tue, 25 Nov 2008 23:52:52 GMTVeena Pandehttp://www.sqlservercentral.com/Forums/Topic608850-149-1.aspxWhat would an SSMS Package be?Tue, 25 Nov 2008 23:40:22 GMTRBarryYounghttp://www.sqlservercentral.com/Forums/Topic608850-149-1.aspxIs there a way to create a quick interface like SSMS to manage SQL tasks for assigning roles?Tue, 25 Nov 2008 22:22:50 GMTVeena Pande