you (we) might find that the "this" is not really needed, and ot is simply a means to a goal.
#SECOND LIFE FORUMS 3 22 2017 HOW TO#
Try to answer to your self: WHY DO YOU WANT THIS, instead of how to do this. Therefore, we cannot discuss any workaround to solve your REAL needs. Secondly, you did not give us any new information regarding the big picture of what you need. The idea of creating chain of sysadmin is a big security breach! Kindly let us know which rights are needed to user 'Sysadminuser", so that we can runįirst I must say that, the entire requirement you ask for, seems like VERY BAD DESIGN! In local server as well. Now using this user's database connection on Master database i want to create other users and also want to runīut getting error for permission as described in my previous post. Run sp_addrolemember 'db_owner','Sysadminuser' Created user "Sysadminuser" on target database where it should be Adminĥ. Sp_addrolemember 'dbmanager','Sysadminuser'Ĥ. Sp_addrolemember 'loginmanager','Sysadminuser' Created user(Sysadminuser) on Master DB for the user to whom i want to assign Sysadmin rights Created login(Sysadminuser) on Master DB for the user to whom i want to assign SysAdmin rightsĢ. Now I want to change that SysAdmin user(e.g. Net application using the sql connection with the SysAdmin's credentials(UserName and password.) With this connection i can able to run query I am creating new Azure SQL Logins from my. * if this does not solve your case, please try to elaborate what you really need, what are the final purposes and not what are the means :-) This way you can use several users that have this option. You can use Azure Active Directory security group account as Unrestricted administrative. In any guess my first guess is that this solution might fit your need: Since Azure SQL Server allows only two administrative accounts that act as administrators we can "bypass" this limitation using security group account instead of individualĪccount. the question is WHY you need this permission and how we can If you elaborate WHY you need this option, then we might find the best solution for yourįor example you want to add to specific user the permission to execute the procedure sp_addrolemember, but again this is not your goal probably. Making the user a sysadmin is probably not your goal, but simply a means to the goals. SysAdmin, but Azure SQL Server can have only two administrative accounts. We need a "wider image" of your case in order to find the best solution for your needs.įor example you say that you need to make a user I am not sure what is your real need, since you only gave us specific point. Kindly send the step by step execution to create it and avoid to send any Blog link. There are no steps mentioned to create SysAdmin user. "Cannot alter the role 'dbmanager', because it does not exist or you do not have permission."
"Cannot alter the role 'loginmanager', because it does not exist or you do not have permission." I want to create SysAdmin user on Azure SQL DB which can run the below query using his connectionĮXEC sp_addrolemember N'loginmanager', ĮXEC sp_addrolemember N'dbmanager',Ĭurrently I am getting following errors after running above queries.
0 kommentar(er)
