Method __CreateUsers

class/databaseModel/sqlserverModel.py:445–453

@创建数据库用户

(self, data_name, username, password, address)

    # 本地创建数据库
    def __CreateUsers(self, data_name, username, password, address):
        """
        @创建数据库用户
        """
        mssql_obj = self.get_mssql_obj_by_sid(self.sid)
        mssql_obj.execute("use %s create login %s with password ='%s' , default_database = %s" % (data_name, username, password, data_name))
        mssql_obj.execute("use %s create user %s for login %s with default_schema=dbo" % (data_name, username, username))
        mssql_obj.execute("use %s exec sp_addrolemember 'db_owner','%s'" % (data_name, data_name))
        mssql_obj.execute("ALTER DATABASE %s SET MULTI_USER" % data_name)

    # 检测备份目录并赋值权限（MSSQL需要Authenticated Users）
    def CheckBackupPath(self, get):