Data Query

Bytebase users query data from SQL Editor. Bytebase can enforce query access control for a particular user at the database, schema or table level.

Assign Project Querier Role

Workspace Admin, Workspace DBA or Project Owner can manually grant Project Querier role to users/groups.

Project level

Select Project and go to Manage > Members. Then Grant Access.

project-members-grant

Select Users or Groups, assign Project Querier role, choose the database object, Expiration and click Confirm.

You can choose the entire database, a particular schema, or a particular table.

project-members-querier

Workspace level

Workspace Admin can assign Project Querier role at the workspace level. This will grant query permission to all databases within all projects.

From the workspace page, go to IAM & Admin > Members, Grant Access to Select users/groups and assign Project Querier to them.

assign-workspace

Request Project Querier Role

This feature is available in Enterprise Plan.

Users can also apply for Project Querier role by submitting an issue.

Project level

Within project page, click Request Query Role. You can either choose all databases or specific databases, schema or tables to request for access.

project-request-querier-role

Click OK and the issue will be created. By configuring custom approval, it will match the corresponding approvers.

bb-issue-querier-role

After the request is approved, you can query data in SQL Editor from the specified databases before the requested expiration time.

bb-issue-querier-done

Within SQL Editor

You can also request the access within SQL Editor.

Enter SQL Editor. Click Select a database to start, and Show databases without query permissions, where you can Request query for database, schema, or a particular table.

sql-editor-request

Restrict data copying in SQL Editor

Applicable to Workspace Admin or Workspace DBA.

Go to Environments, If Restrict data copying in SQL Editor is checked, then no one can copy data from databases belonging to that environment via SQL Editor.

restrict-data-copy

Edit this page on GitHub

Subscribe to Newsletter

By subscribing, you agree with Bytebase's Terms of Service and Privacy Policy.