URA Database Security Logins

Type topic text here.


 

Security Login Accounts created by URA database scripts

 

 

 

Default SysAdmin Login Account - sa

When you install the database engine a SysAdmin (sa) account is created which gives you complete control over all the databases managed by the machine upon which you have installed the database.

Note: You should change the 'sa' account's default password as soon as possible after installing your database engine. It is also good practice to create another Security Login Account and grant it SysAdmin rights so that you can use it instead of the 'sa' account which should then be disabled.


How to Create a Security Login Account

 

How to Change the Name and Password of a  Security Login Account

 

 

How to Grant SysAdmin rights to a Security Login Account

You can grant other Security Login accounts with the same rights as the SysAdmin account as follows:

  1. Start the Database Management Studio and connect to your database engine by logging on with the default SysAdmin account

  2. ...

Note: you should not grant SysAdmin rights to URA-Admin, but instead create another Security Login account for this purpose. In this way your osImageManager configuration file will have a different name for the URA-Admin and SysAdmin items.

How to Change the 'sa' Password

How to Disable the 'sa' Account