Configuring Future Tables Permissions
During the configuration of a role or permission set, if a user is assigned the permissions of all tables in a schema of the DWS data source (that is, the data table in the permission is set to *), this user has permissions on all tables in the schema. Due to the restrictions of DWS permissions, these permissions are applicable only to the current table. This user has no permissions on the tables (future tables) created after permission synchronization. In this case, the administrator must manually synchronize permissions of the role or permission set so that the user has permissions on future tables.
To avoid manually synchronizing the permissions on future tables, you can configure the users for creating future tables in a specified schema. When these users create future tables in the specified schema, all the users that have full table permissions on the schema in the current instance automatically obtain the permissions on the created future tables.

In the new version mode, you can configure future table permissions only when you are using the enterprise version. In the old version mode, this function is supported in the basic version or an advanced version.
Prerequisites
- Before permission set configuration, a DWS data connection has been created in 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 the schema view, a maximum of 200 future table users can be configured for a schema in a database. In the future table user view, a maximum of 200 schemas can be configured for a future table user.
Configuring Future Table Users for a Schema (Schema View)
You can configure multiple future table users for a schema.
- On the DataArts Studio console, locate a workspace and click DataArts Security.
- In the navigation pane on the left, choose Permission Applications. On the displayed page, click the Future Table Permissions tab.
- On the Future Table Permissions page, select the DWS data connection for which you want to configure future table permissions and click
to add a database.
Figure 1 Selecting a DWS data connectionFigure 2 Adding a database - Select a database and click Create on the Schema View tab page to create a future table configuration.
Figure 3 Creating a future table configuration
- In the displayed dialog box, configure users for creating future tables for a specified schema and click OK.
Figure 4 Future table configuration
- After the configuration is successful, click Synchronise.
After the synchronization is complete, when these users create future tables in the specified schema, all the users that have full table permissions on the schema in the current instance automatically obtain the permissions on the created future tables.
Figure 5 Synchronizing the future table configuration
Configuring Schemas for a Future Table User (Future Table User View)
You can configure multiple schemas for a future table user at a time.
- On the DataArts Studio console, locate a workspace and click DataArts Security.
- In the navigation pane on the left, choose Permission Applications. On the displayed page, click the Future Table Permissions tab.
- On the Future Table Permissions page, select the DWS data connection for which you want to configure future table permissions and click
to add a database.
Figure 6 Selecting a DWS data connectionFigure 7 Adding a database - Select a database and click Create on the Future Table User View tab page to create a future table configuration.
Figure 8 Creating a future table configuration
- In the displayed dialog box, configure schemas for a user for creating future tables and click OK.
Figure 9 Future table configuration
- After the configuration is successful, click Synchronise.
After the synchronization is complete, when the user creates future tables in a specified schema, all the users that have full table permissions on the schema in the current instance automatically obtain the permissions on the created future tables.
Figure 10 Synchronizing the future table configuration
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot