Create a Database User
Visual Guard allows you to re-use user accounts and passwords defined in these DBMS.
- 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.
- 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.
- Right click on the Repository >Users menu provided on the Left Navigation Panel and select Add Database User option (A).
- Select the Repository from Left Navigation Panel and select the Add Database User menu item from Action Menu (B).
- The Select a database account screen will be displayed as shown below:
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 “OK” .
- Add database account screen will be displayed as shown below:
- To create a new user account you have to provide the following details:
- After specifying the roles for the user, click “OK” to save the user details.
- Click “Cancel” if you do not want to create the user.
- The new user account (A) will be displayed under Users menu in Right Panel.
- All Database Users are represented with a different icon i.e.
- Modifying Database User Account
- Grant Roles to multiple users
- Grant Groups to multiple users
- Deleting Database User Account
- Filter and Select User