Workspace Admin
, Workspace DBA
, Workspace Member
.
The workspace role maps to the roles at the organization level. Every Bytebase user has Workspace Member
role.
Users can also be granted Workspace Admin
, Workspace DBA
. These 2 roles should be granted judiciously though.
Project Roles
Project Owner
, Project Developer
, Project Releaser
, SQL Editor User
(previously called Project Querier
), Project Exporter
, Project Viewer
.Workspace Member
role, most users will be granted project roles. These roles
allow users to perform specific database operations.
Workspace DBA
and a Project Owner
for Project Apollo at the same time.
Workspace Member
, a Project Owner
for Project Apollo and a Project Developer
for Project Mars at the same time.
Admin
role, all following registered users are granted Member
role. Admin
can update any user’s role later.
Workspace Permission | Member | DBA | Admin |
---|---|---|---|
Change own name and password | ✔️ | ✔️ | ✔️ |
Add new user | ✔️ | ||
View all users | ✔️ | ✔️ | ✔️ |
Change any user’s role | ✔️ | ||
De-activate/re-activate user | ✔️ | ||
Change any user’s name and password | ✔️ | ||
Add environment | ✔️ | ✔️ | |
View all environments | ✔️ | ✔️ | ✔️ |
Edit environment | ✔️ | ✔️ | |
Reorder environment | ✔️ | ✔️ | |
Archive environment | ✔️ | ✔️ | |
View all instances | ✔️ | ✔️ | |
Add instance | ✔️ | ✔️ | |
Edit instance | ✔️ | ✔️ | |
Archive instance | ✔️ | ✔️ | |
Sync instance schema | ✔️ | ✔️ | |
Create database | ✔️ | ✔️ | |
View all databases | ✔️ | ✔️ | |
Create project | ✔️ | ✔️ | ✔️ |
View all projects | ✔️ | ✔️ | |
Create issue | ✔️ | ✔️ | |
View all issues | ✔️ | ✔️ | |
Become issue assignee | ✔️ | ✔️ | |
Re-assign issue | ✔️ | ✔️ | |
Add comment to all issues | ✔️ | ✔️ | |
Subscribe to all issues | ✔️ | ✔️ | |
Alter schema | ✔️ | ✔️ | |
Change data | ✔️ | ✔️ | |
Configure SQL Review Policy | ✔️ | ✔️ | |
Manage version control system (VCS) | ✔️ | ||
Manage sensitive data | ✔️ | ✔️ | |
Manage database access control | ✔️ | ✔️ | |
Manage IM integration | ✔️ | ||
Change logo | ✔️ |
Project Owner
role.
Workspace DBA
and Workspace Admin
assume the Project Owner
role for all projects.
Project Permission | SQL Editor User | Project Exporter | Project Developer | Project Owner | Workspace DBA | Workspace Admin |
---|---|---|---|---|---|---|
Change project role | ✔️ | ✔️ | ✔️ | |||
Edit project | ✔️ | ✔️ | ✔️ | |||
Archive project | ✔️ | ✔️ | ✔️ | |||
Configure UI/GitOps workflow | ✔️ | ✔️ | ✔️ |
Database Permission | SQL Editor User | Project Exporter | Project Developer | Project Owner | Workspace DBA | Workspace Admin |
---|---|---|---|---|---|---|
Query | ✔️ | ✔️ | ✔️ | ✔️ | ||
Export | ✔️ | ✔️ | ✔️ | ✔️ | ||
Edit database label | ✔️ | ✔️ | ✔️ | |||
Transfer database | ✔️ | ✔️ | ✔️ |
Permission | Creator | SQL Editor User | Project Exporter | Project Developer | Project Owner | Workspace DBA | Workspace Admin |
---|---|---|---|---|---|---|---|
Star | ✔️ | ||||||
Read | ✔️ | ||||||
Write | ✔️ | ||||||
Delete | ✔️ |
Permission | Creator | SQL Editor User | Project Exporter | Project Developer | Project Owner | Workspace DBA | Workspace Admin |
---|---|---|---|---|---|---|---|
Star | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Read | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Write | ✔️ | ✔️ | ✔️ | ✔️ | |||
Delete | ✔️ | ✔️ | ✔️ | ✔️ |
Permission | Creator | SQL Editor User | Project Exporter | Project Developer | Project Owner | Others |
---|---|---|---|---|---|---|
Star | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Read | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Write | ✔️ | ✔️ | ||||
Delete | ✔️ | ✔️ |
Issue Permission | Assignee | Creator | SQL Editor User | Project Exporter | Project Developer | Project Owner | Workspace DBA | Workspace Admin |
---|---|---|---|---|---|---|---|---|
Create issue | N/A | N/A | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
Change issue status | ✔️ | Depends* | ✔️ | ✔️ | ||||
Edit name and description | ✔️ | ✔️ | ✔️ | ✔️ | ||||
Edit SQL Statement | ✔️ | |||||||
Subscribe/Unsubscribe | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Add comment | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Project Owner
can change issue status when the current active Environment Rollout Policy is set to Require manual rolling out.