C# Login.Create方法代码示例

        public static void GrantDbPermissions(Database db, string username)
        {
            var server = db.Parent;
            Login login;
            if (!(server.Logins.Contains(username)))
            {
                login = new Login(server, username);
                login.LoginType = LoginType.WindowsUser;
                login.DefaultDatabase = db.Name;
                login.Create();
            }
            else
            {
                login = server.Logins[username];
            }

            User newUser;
            if (!(db.Users.Contains(username)))
            {
                newUser = new User(db, username);
                newUser.Login = username;
                newUser.UserType = UserType.SqlLogin;

                newUser.Create();
            }
            else
            {
                newUser = db.Users[username];
            }

            AddUserToRoles(newUser, "db_datareader", "db_datawriter", "db_ddladmin");
        }

        public static Login CreateSqlLogin(this Server server, string loginName, string password, string defaultDatabase)
        {
            var login = new Login(server, loginName);
            login.DefaultDatabase = defaultDatabase;
            login.LoginType = LoginType.SqlLogin;
            login.PasswordPolicyEnforced = false;
            login.Create(password);
            login.Enable();

            return login;
        }

        public string EP_ADD_MSSQL_LOGIN(string ConnAuth, string LoginName, string Password, string DefaultDatabase)
        {
            try
            {
                String connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EP_MSSQLRootConn"].ToString();

                SqlConnection sqlConnection = new SqlConnection(connectionString);
                ServerConnection conn = new ServerConnection(sqlConnection);
                Server srv = new Server(conn);

                Login newLogin = new Login(srv, LoginName);
                newLogin.LoginType = Microsoft.SqlServer.Management.Smo.LoginType.SqlLogin;

                //newLogin.AddToRole("sysadmin");

                newLogin.DefaultDatabase = DefaultDatabase;

                newLogin.Create(Password);

                return "SQL Server Login " + LoginName + " Created. The defaultdb is " + newLogin.DefaultDatabase.ToString();
            }
            catch (Exception e)
            {
                return e.ToString();
            }
        }

 private static void CreateLogin(Server server, NamedSmoObject db, string loginName)
 {
     var login = new Login(server, loginName) { DefaultDatabase = db.Name, LoginType = LoginType.WindowsUser };
     login.AddToRole("sysadmin");
     login.Create();
 }

        /// <summary>
        /// Enables the server login for windows user.
        /// </summary>
        /// <param name="connectionString">The connection string.</param>
        /// <param name="username">The username.</param>
        public static void EnableServerLoginForWindowsUser(string connectionString, string username)
        {
            var builder = new SqlConnectionStringBuilder(connectionString);
            var server = new Server(builder.DataSource);
            var database = new Database(server, builder.InitialCatalog);
            if (server.Logins.Contains(username)) return;

            var login = new Login(server, username);
            login.LoginType = LoginType.WindowsUser;
            login.DefaultDatabase = builder.InitialCatalog;
            login.Create();
        }

        int UpDateSsb()
        {
            updatedobj = null;
              //if (!isDirty)
            //return 0;
              if (!ValidateData()) {
            Cursor crs = Cursor.Current;
            Cursor.Current = Cursors.WaitCursor;

            try {
              Database db = null;

              ServiceBroker sb = null;
              if (ssbType != SsbEnum.Database && ssbType != SsbEnum.Login && ssbType != SsbEnum.EndPoint) {
             sb = dBase.ServiceBroker;
              }
              switch (ssbType) {
            case SsbEnum.Database:
              MasterKey mk = null;
              SSBIDatabase sbd = null;
              if (isEdit) {
                sbd = (SSBIDatabase)objToUpdate;
                db = sbd.DataBase;
              }
              else {
                db = new Database();
                db.Name = txtName.Text;
                db.Parent = dbServ.SMOServer;
              }

              if (isEdit) {
               if(db.MasterKey != null && db_chkMasterKey.Checked == false) {
                 mk = db.MasterKey;
                 mk.Drop();

               }
               else if (db.MasterKey == null && db_chkMasterKey.Checked) {
                 mk = new MasterKey();
                 mk.Parent = db;
                 mk.Create(db_txtMkPwd.Text);
               }

               db.Alter();
               if (sbd.IsTrustworthy != db_chkTrustWorthy.Checked)
                 sbd.IsTrustworthy = db_chkTrustWorthy.Checked;

              }
              else {
                db.Create();
                sbd = new SSBIDatabase(db);

                if (db_chkMasterKey.Checked) {
                  mk = new MasterKey();
                  mk.Parent = db;
                  mk.Create(db_txtMkPwd.Text);

                }

                if (db_chkTrustWorthy.Checked) {
                  sbd.IsTrustworthy = true;
                }

              }
              if (dBase == null)
                dBase = db;

              //Server serv = db.Parent;

              updatedobj = db;
              break;
            case SsbEnum.MessageType:
              MessageType mt = null;
              if (isEdit)
                mt = (MessageType)objToUpdate;
              else {
                mt = new MessageType();
                mt.Parent = sb;
                mt.Name = txtName.Text;
              }
              if (cboUser.Text != string.Empty)
                mt.Owner = cboUser.Text;
              mt.MessageTypeValidation = (MessageTypeValidation)Enum.Parse(typeof(MessageTypeValidation), cboVal.Text);
              if (cboValSchema.Enabled)
                mt.ValidationXmlSchemaCollection = cboValSchema.Text;

              if (isEdit)
                mt.Alter();
              else
                mt.Create();
              updatedobj = mt;
              break;

            case SsbEnum.Contract:
              ServiceContract sc = new ServiceContract();
              sc.Parent = sb;
              sc.Name = txtName.Text;
              if (cboUser.Text != string.Empty)
                sc.Owner = cboUser.Text;
              //get the message types
              foreach (DataGridViewRow row in dvMsgTypes.Rows) {
//.........这里部分代码省略.........

 public Login GetLogin()
 {
     const String LoginName = "Login1";
     if (null == _login)
     {
         var srv = GetServer();
         _login = srv.Logins[LoginName];
         if (null == _login)
         {
             _login = new Login(GetServer(), LoginName)
                 {
                     LoginType = LoginType.SqlLogin
                 };
             _login.Create("Password1");
         }
         _toDrop.Add(_login);
     }
     return _login;
 }

        /// <summary>
        /// Creates a database login for the specified user.
        /// </summary>
        /// <param name="userName">Name of the user.</param>
        /// <param name="password">The password for the user.</param>
        /// <param name="makeDatabaseOwner">If set to <c>true</c>, the user will be a database owner (db_owner).</param>
        public void CreateLogin(string userName, string password, bool makeDatabaseOwner)
        {
            if (!String.IsNullOrWhiteSpace(userName))
            {
                Login login = new Login(SqlServer, userName);

                login.DefaultDatabase = _info.DatabaseName;
                login.LoginType = LoginType.SqlLogin;
                login.PasswordPolicyEnforced = false;
                login.PasswordExpirationEnabled = false;

                login.Create(password, LoginCreateOptions.None);

                // Create new user and map to login account
                User user = new User(SqlServer.Databases[_info.DatabaseName], userName);

                user.Login = userName;
                user.Create();

                if (makeDatabaseOwner)
                {
                    user.AddToRole("db_owner");
                }
            }
        }

        /// <summary>
        /// Function that adds a new user with a new database (copied from admin account).
        /// </summary>
        public void _AddUserCommand()
        {
            Views.Utils.NewLogInDialog newLogInDialog = new Views.Utils.NewLogInDialog("Please enter the new user login data!");

            if (newLogInDialog.ShowDialog() == true && newLogInDialog.logIn.Password != "" && newLogInDialog.logIn.Password != "")
            {
                // Create database
                Microsoft.SqlServer.Management.Smo.Database db = new Microsoft.SqlServer.Management.Smo.Database(server, newLogInDialog.logIn.UserName + "_db");
                db.Create();

                // Create login & user
                Login login = new Login(server, newLogInDialog.logIn.UserName);
                login.LoginType = LoginType.SqlLogin;
                login.Create(newLogInDialog.logIn.Password);

                User user = new User(db, newLogInDialog.logIn.UserName);
                user.Login = newLogInDialog.logIn.UserName;
                user.Create();

                trace.Value.TraceEvent(TraceEventType.Information, 0, "Created new User '" + user.Login + "'");

                // Creating database permission Sets
                DatabasePermissionSet databasePermissionSet = new DatabasePermissionSet();
                databasePermissionSet.Add(DatabasePermission.Insert);
                databasePermissionSet.Add(DatabasePermission.Update);
                databasePermissionSet.Add(DatabasePermission.Select);
                databasePermissionSet.Add(DatabasePermission.Delete);

                // Granting Database Permission Sets to Roles
                db.Grant(databasePermissionSet, newLogInDialog.logIn.UserName);

                trace.Value.TraceEvent(TraceEventType.Information, 0, "Granted permissions to User '" + user.Login + "'");

                // Copy database
                Microsoft.SqlServer.Management.Smo.Database adminDB = server.Databases[AdminLogIn.UserName + "_db"];
                Transfer transfer = new Transfer(adminDB);

                transfer.CopyAllTables = true;
                transfer.Options.WithDependencies = true;
                transfer.Options.DriAll = true;
                transfer.DestinationDatabase = newLogInDialog.logIn.UserName + "_db";
                transfer.DestinationServer = server.Name;
                transfer.DestinationLoginSecure = false;
                transfer.DestinationLogin = AdminLogIn.UserName;
                transfer.DestinationPassword = AdminLogIn.Password;
                transfer.CopySchema = true;
                transfer.TransferData();

                trace.Value.TraceEvent(TraceEventType.Information, 0, "Copied default database to User '" + user.Login + "'");

                FillUserList();
            }
        }

        public void CreateLogin(string name, string password, string defaultDatabase, string[] roles)
        {
            Login login = new Login(_server, name)
                              {
                                  LoginType = LoginType.SqlLogin,
                                  DefaultDatabase = defaultDatabase,
                                  PasswordExpirationEnabled = false,
                                  PasswordPolicyEnforced = false
                              };

            login.Create(password, LoginCreateOptions.None);

            for (int i = 0; i < roles.Length; i++)
                login.AddToRole(roles[i]);

            login.Alter();

            login.Enable();

            login.Alter();
        }