Manage roles

This topic describes how to modify a role and its system privileges, and add objects.

Procedure

1. Log on to the OceanBase Cloud Platform (OCP) console. In the left-side navigation pane, click Tenants . The Tenant Overview page appears.

2. Find the target tenant in the Tenants list, and click the tenant name. The details page of the Oracle tenant appears.

3. In the left-side navigation pane, click User Management . On the page that appears, click the Roles tab.

4. Find the target role in the Roles list, and click the role name. The role details page appears.

   1. Click Modify System Permissions . In the dialog box that appears, select privileges from the drop-down list or remove existing permissions.

      

   2. Click Modify Role . In the dialog box that appears, select roles from the drop-down list.

      

   3. Click Add Object . In the dialog box that appears, specify the following information:

      Parameter	Description
      Object Type	Available options: Table, View , and Storing Procedure .
      Object	You can paste one or more objects into the field in the format of "username.object name", such as schemaname.tablename. Separate objects with commas (,).
      Grant Permission	Select the privileges as needed. For more information, see System privileges.

      

5. Click OK . You can view whether the modification succeeds in the Roles list.