ManageEngine® SQLDBManager Plus
SQL User Details
ManageEngine SQLDBManagerPlus User Details section displays the entire list of active users of SQL servers. It displays the Username, Status, Login Type and Creation Date along with the option to edit the user. The DBA can also, quite easily, do bulk edit the list of users. This bulk edit option includes Enable User, Disable User and Delete User.
You can create new user accounts and map them to specific SQL servers without actually logging into the SQL server. You can then set restrictions by assigning server and db roles to the user thereby reducing the risk of unauthorized access to mission-critical data. Further, SQLDBManager Plus allows you to enforce Password Policy set for SQL servers for each user. This in turns tightens the security even further. You can go also one step further and set expiration dates for the password created further reducing the risk of hacking by using old passwords. Through SQLDBManager Plus, you can enable the user to change passwords when the user login, thereby greatly reducing any security risk.
Once you have created the user name and password, click on 'Create' to create the user account. You can also revisit the user settings and change the roles and re-map the user to the desired database at any point in time.
Note: The "password change option" is applicable only for Windows 2003 Server machine.
Assign SQL Server Roles:
ManageEngine SQLDBManager Plus allows DBA to assign SQL server roles to the user account. Some of the server roles that are currently supported are:
Once you have selected the appropriate SQL server role for the user, click on 'Create' and the user account is created along with correct server roles applied to them.
ManageEngine SQLDBManager Plus displays the entire list databases monitored, allowing the you to map the user to a particular database along based on their database roles. The list of database roles currently supported are :
To map the user, simply select the database and check the db roles for the user. Once this is done, click on 'Create'.
Note: msdb database contains special-purpose roles. For more information on these roles, visit MSDN help documentation.