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.
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.
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.
Request Project Querier Role
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.
Click OK and the issue will be created. By configuring custom approval, it will match the corresponding approvers.
After the request is approved, you can query data in SQL Editor from the specified databases before the requested expiration time.
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.
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.