Manage Users
The Access Management page in the web console provides you with a high-level overview of users who are a part of your organization. You can view the user's status, roles, and the databases to which they have access. In addition, you can also add new users or delete users. The search box allows you to search for a specific user.
To view the Admin tab in the web console and to be able to invite users, you must have the owner role.
Invite New Users
As an account owner, do the following to invite a new user to the account:
- In the web console, click
Users.
- Click the Invite user button in the top right corner of the screen.
- In the invite wizard, enter the following details and then click Next:
- In the Email field, enter the email address for the user.
- From the Organization role drop-down menu, select a role you want to assign to the user (Member or Owner).
- In the Database username field, enter a unique name to identify the user. A database user with this name will be created on each database specified in the next field. If the database user name you enter already exists, you will see an error message.
- For each database the user should access, select the database role the user receives.
- No Access: User has no visibility and no access to the database.
- Public: User can view the database in the web console and connect to the database and run queries.
- Click Invite to send the invitation.
Additional privileges can be granted to the user using SQL. To learn more about database privileges, see Privileges.
The user will receive an email with the link to accept the invitation and complete their profile. As the account owner you will have the option to click on the Grant Privileges button, which will take you to a worksheet with some example privileges you can grant to the user.
Users who have not accepted the invitation and completed their profile have the status Invited with an empty name. When a user completes their profile, the NAME field will be updated with the user's name. The ACTIVE status indicates the user has completed their profile and has an account.
Edit Users
As an account owner, you can edit a user's assigned roles for the web console and change which databases the user can access. To edit a user, do the following:
- In the web console, click
Users.
- Using the search box, find the user you want to edit.
- In the row of the user you want to edit, click
and select Edit from the drop-down menu.
- Change the user's organizational role if needed, otherwise leave it as it is, then click Next.
- Select the desired role from the drop-down for each database that the user can access.
- Click Update.
Removing access to a database will drop the corresponding user in the database.
To prevent data loss, if the user being deleted was the owner of any schemas, the owner is changed to SYS automatically before the user is dropped. In addition, any user with a DBA role can view the schemas and change the owner as needed.
Remove Users
As an account owner, you can remove any user from an account. To remove a user, do the following:
- In the web console, click
Users.
- Using the search box, find the user you want to delete from the account.
- In the row of the user you want to delete, click
and select Remove from the drop-down menu.
- In the confirmation window, click Delete.
Deleting a user will also delete them from any databases they had access to.
To prevent data loss, if the user being deleted was the owner of any schemas, the owner is changed to SYS automatically before the user is dropped. In addition, any user with a DBA role can view the schemas and change the owner as needed.