Search code examples
sql-server-2005permissionsauthenticationsmo

Using SMO to create and set Database permissions?


Is there a way to create new logins and set database permissions on a SQL Server 2005 using C# and SMO?

If so, how? If not, what is the best way of doing that?


Solution

  • You can use the Microsoft.SqlServer.Management.Smo.Login class and call the Create method. See here for more details.