Visual Guard allows you to re-use user accounts and passwords defined in these DBMS.
Note:
You will be allowed to create the user accounts only if you have been assigned the privilege. Refer special roles section for more details on privilege
This option will be available only for SQL or Oracle repositories only.
Follow the steps below to create a Database User:
Login to the Repository under which user account(s) is to be created.
Screen Display
Access the Add Database User menu using one of the options below:
Right click on the Repository Name provided on the Left Navigation Panel and select Add Database User option.
OR
Right click on the Repository >Users menu provided on the Left Navigation Panel and select Add Database User option (A).
OR
Select the Repository from Left Navigation Panel and select the Add Database User menu item from ActionMenu(B).
The Select a database account screen will be displayed as shown below:
Screen Display
Note:
The list of accounts will only be displayed if the user account created in the sql server has server roles as sysadmin.
Select the database from the available accounts and click .
Add database account screen will be displayed as shown below:
Screen Display
To create a new user account you have to provide the following details:
Field Name
Description
Database Account
This option displays the name of the database account that you selected.
You can select a different user by clicking .
Role Assignment:
This section displays the list of available and assigned roles. You can grant or revoke the roles using this section. Refer Grant Role or Revoke
List of Roles
This screen displays the list of roles.
Current Roles
This section displays the list of roles that have been already assigned to the user.
Display 'Membership' roles
This option allows you to display the membership access level to membership API for the application.
The user can be assigned
Unrestricted, Membership Members Only only or Add Members role only.
Screen Display
After specifying the roles for the user, click to save the user details.
Click if you do not want to create the user.
The new user account (A) will be displayed under Users menu in Right Panel.
Screen Display
All Database Users are represented with a different icon i.e.
Unrestricted is the default Membership Access Level. This access level indicates that all users can use Membership API for creating, editing,deleting or granting roles to users.
Membership Members Only indicates that the users that are members of Membership Manager role can use Application API. This access level indicates that all users can use Membership API
Add Members indicates that all the users can create users and assign the default role of the application.