Using SMO to Create and Set Database Permissions?

Question

Is there a way to create new logins and set database permissions on SQL Server 2005

using C#

and SMO

?

If so, how? If not, what is the best way to do this?

0

Mephisztoe 21 nov. '08 at 9:06

1 answer

RedFilter · Accepted Answer · 2008-11-23T06:03:33+0000

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