Data Access Control

Data Access Control restricts how the Workspace Developer access and export the data. Workspace Owner or DBA are exempt from these restrictions.

At the project level, a Workspace Developer can be a Project Owner or Project Developer. The Project Owner is also exempt from these restrictions. And for Project Developer, Workspace Owner or DBA can configure the following data access control:

• Query: query data via SQL Editor
• Export: export data by SQL or Database
• Copy from SQL Editor: copy data from the query result table in SQL Editor

Configure Data Access Control

This section is for Workspace Owner or DBA to configure data access control for Project Developer.

1. Click Settings > Security & Policy > Data Access Control.

2. If Skip approval for Query Data is checked, then by default Project Developer can query data from databases belonging to that Environment via SQL Editor; If unchecked, then Project Developer needs to Request Query for approval.

3. If Skip approval for Export Data is checked, then by default Project Developer can export data from databases belonging to that Environment via SQL Editor; If unchecked, then Project Developer needs to Request Export for approval.

For how to request approval, please refer to Request Query and Request Export.

1. If Disallowed for Copy Data From SQL Editor is checked, then no one can copy data from databases belonging to that Environment via SQL Editor; If unchecked, then all can copy data.