本文整理汇总了C#中Login.Create方法的典型用法代码示例。如果您正苦于以下问题:C# Login.Create方法的具体用法?C# Login.Create怎么用?C# Login.Create使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Login
的用法示例。
在下文中一共展示了Login.Create方法的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GrantDbPermissions
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");
}
示例2: CreateSqlLogin
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;
}
示例3: EP_ADD_MSSQL_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();
}
}
示例4: CreateLogin
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();
}
示例5: EnableServerLoginForWindowsUser
/// <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();
}
示例6: UpDateSsb
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) {
//.........这里部分代码省略.........
示例7: GetLogin
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;
}
示例8: CreateLogin
/// <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");
}
}
}
示例9: _AddUserCommand
/// <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();
}
}
示例10: CreateLogin
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();
}