Configuring Permissions for Future Tables

Prerequisites

• Before configuring the permission set, you have created a DWS data connection in the management center. For details, see Creating a DataArts Studio Data Connection.

Notes and Constraints

• The specified future table user must have the create permission in the corresponding schema.
• In a single database, a maximum of 200 future table users can be configured for a single schema in the schema view, and a maximum of 200 schemas can be configured for a single future table user in the future table user view.

Configuring Future Table Users for a Schema (Schema View)

You can configure multiple future table users for a schema.

1. On the DataArts Studio console, locate a workspace and click DataArts Security.
2. In the navigation pane, choose Permission Applications. On the Permission Applications page, click the Future Table Permissions tab.
3. On the Future Table Permissions page, select the DWS data connection for which you want to configure future table permissions in the data connection area and click next to the selected data connection to add a database.
   Figure 1 Selecting a DWS data connection
   
   Figure 2 Adding a database
   

4. Click the database to be configured. On the Schema view page, click Create to create a future table configuration.
   Figure 3 Creating a future table configuration
   

5. In the dialog box that is displayed, configure a table creation user for the specified schema and click OK.
   Figure 4 Future Table Configuration
   

6. After the configuration is successful, click Synchronise.

   After the synchronization is complete, when a future table user creates a future table in a specified schema, all users who have the full table permission on the schema in the current instance automatically obtain the corresponding permission on the created future table.

   Figure 5 Synchronizing the future table configuration
   

Configuring a Schema for Future Table Users (Future Table User View)

You can configure multiple schemas for a future table user at a time.

1. On the DataArts Studio console, locate a workspace and click DataArts Security.
2. In the navigation pane, choose Permission Applications. On the Permission Applications page, click the Future Table Permissions tab.
3. On the Future Table Permissions page, select the DWS data connection for which you want to configure future table permissions in the data connection area and click next to the selected data connection to add a database.
   Figure 6 Selecting a DWS data connection
   
   Figure 7 Adding a database
   

4. Click the database to be configured. On the Future Table User View page, click Create to create a future table configuration.
   Figure 8 Creating a future table configuration
   

5. In the dialog box that is displayed, specify a schema for the user who will create the table and click OK.
   Figure 9 Future table configuration
   

6. After the configuration is complete, click Synchronise.

   After the synchronization is successful, when a future table user creates a future table in a specified schema, all users who have the full table permission on the schema in the current instance automatically obtain the corresponding permission on the created future table.

   Figure 10 Synchronizing the future table configuration