This topic describes the operation permission list for standard modeling, data processing, and ad hoc query.
Symbol description
Y indicates that the role has this feature permission; N indicates that the role does not have this feature permission; - indicates that the role is not related to this feature permission.
More role descriptions
Custom project roles in Dataphin are based on the product's features and manage permissions for multiple modules such as data warehouse planning, Data Integration, data development, project asset permissions, and publishing operations and maintenance.
Global permission list
Permission point | Project administrator | Project developer | Project visitor | Project analyst | General member |
Global search resources | Y | Y | Y | Y | N |
Global search code | Y | Y | Y | Y | N |
Tab object - locate menu tree | Y | Y | Y | Y | N |
View global physical table | Y | Y | Y | Y | N |
Query global physical table | Y (project + request permission) | Y (project + request permission) | Y (project + request permission) | Y (project + request permission) | N |
Update global physical table | Y (project) | Y (mine) | Y (mine) | Y (mine) | N |
Delete global physical table | Y (mine) | Y (mine) | Y (mine) | Y (mine) | N |
Standard modeling permission list
<
Permission point | Project administrator | Project developer | Project visitor | Project analyst | General member |
Logical dimension table | |||||
View logical dimension table | Y | Y | Y | Y | N |
Edit logical dimension table | Y | Y | N | N | N |
Save logical dimension table | Y | Y | N | N | N |
Delete logical dimension table | Y | Y | N | N | N |
Unpublish logical dimension table | Y | Y | N | N | N |
Submit logical dimension table | Y | Y | N | N | N |
Logical fact table | |||||
View logical fact table | Y | Y | Y | Y | N |
Create logical fact table | Y | Y | N | N | N |
Edit logical fact table | Y | Y | N | N | N |
Save logical fact table | Y | Y | N | N | N |
Delete logical fact table | Y | Y | N | N | N |
Unpublish logical fact table | Y | Y | N | N | N |
Submit logical fact table | Y | Y | N | N | N |
Logical aggregate table | |||||
View logical aggregate table | Y | Y | Y | Y | N |
Create logical aggregate table | Y | Y | N | N | N |
Edit logical aggregate table | Y | Y | N | N | N |
Delete logical aggregate table | Y | Y | N | N | N |
Submit logical aggregate table | Y | Y | N | N | N |
Business process | |||||
View business process | Y | Y | Y | Y | N |
Create business process | Y | Y | Y | Y | Y |
Edit business process | Y | Y | Y | Y | Y |
Save business process | Y | Y | Y | Y | Y |
Delete business process | Y | Y | Y | Y | Y |
Unpublish business process | Y | Y | Y | Y | Y |
Submit business process | Y | Y | Y | Y | Y |
Atomic metric | |||||
View atomic metric | Y | Y | Y | Y | N |
Create atomic metric | Y | Y | N | N | N |
Edit atomic metric | Y | Y | N | N | N |
Save atomic metric | Y | Y | N | N | N |
Delete atomic metric | Y | Y | N | N | N |
Unpublish atomic metric | Y | Y | N | N | N |
Submit atomic metric | Y | Y | N | N | N |
Business filter | |||||
View business filter | Y | Y | Y | Y | N |
Create business filter | Y | Y | N | N | N |
Edit business filter | Y | Y | N | N | N |
Save business filter | Y | Y | N | N | N |
Delete business filter | Y | Y | N | N | N |
Unpublish business filter | Y | Y | N | N | N |
Submit business filter | Y | Y | N | N | N |
Derived metric | |||||
View derived metric | Y | Y | Y | Y | N |
Create derived metric | Y | Y | N | N | N |
Edit derived metric | Y | Y | N | N | N |
Save derived metric | Y | Y | N | N | N |
Delete derived metric | Y | Y | N | N | N |
Unpublish derived metric | Y | Y | N | N | N |
Submit derived metric | Y | Y | N | N | N |
Data processing permission list
Permission point | Project administrator | Project developer | Project visitor | Project analyst | General member |
SQL code task folder | |||||
View SQL code task folder | Y | Y | Y | Y | N |
Create SQL code task folder | Y | Y | N | N | N |
Edit SQL code task folder | Y | Y | N | N | N |
Confirm SQL code task folder | Y | Y | N | N | N |
Delete SQL code task folder | Y | Y | N | N | N |
SQL code task | |||||
View SQL code task | Y | Y | Y | Y | N |
Create SQL code task | Y | Y | N | N | N |
Edit SQL code task | Y | Y | N | N | N |
Save SQL code task | Y | Y | N | N | N |
Delete SQL code task | Y | Y | N | N | N |
Unpublish SQL code task | Y | Y | N | N | N |
Submit SQL code task | Y | Y | N | N | N |
Refresh SQL code task | Y | Y | N | N | N |
Shift SQL code task | Y | Y | N | N | N |
Execute SQL code task code | Y | Y | N | N | N |
Precompile SQL code task code | Y | Y | N | N | N |
Format SQL code task code | Y | Y | N | N | N |
Shell, Python, Spark, MR code task folder | |||||
View Shell, Python, Spark, MR code task folder | Y | Y | Y | Y | N |
Create Shell, Python, Spark, MR code task folder | Y | Y | N | N | N |
Edit Shell, Python, Spark, MR code task folder | Y | Y | N | N | N |
Confirm Shell, Python, Spark, MR code task folder | Y | Y | N | N | N |
Delete Shell, Python, Spark, MR code task folder | Y | Y | N | N | N |
View Shell, Python, Spark, MR code task | Y | Y | Y | Y | N |
Create Shell, Python, Spark, MR code task | Y | Y | N | N | N |
Edit Shell, Python, Spark, MR code task | Y | Y | N | N | N |
Save Shell, Python, Spark, MR code task | Y | Y | N | N | N |
Delete Shell, Python, Spark, MR code task | Y | Y | N | N | N |
Unpublish Shell, Python, Spark, MR code task | Y | Y | N | N | N |
Submit Shell, Python, Spark, MR code task | Y | Y | N | N | N |
Refresh Shell, Python, Spark, MR code task | Y | Y | N | N | N |
Shift Shell, Python, Spark, MR code task | Y | Y | N | N | N |
Execute Shell, Python, Spark, MR code task code | Y | Y | N | N | N |
Virtual code task folder | |||||
View Virtual code task folder | Y | Y | Y | Y | N |
Create Virtual code task folder | Y | Y | N | N | N |
Edit Virtual code task folder | Y | Y | N | N | N |
Confirm Virtual code task folder | Y | Y | N | N | N |
Delete Virtual code task folder | Y | Y | N | N | N |
View Virtual code task | Y | Y | Y | Y | N |
Create Virtual code task | Y | Y | N | N | N |
Edit Virtual code task | Y | Y | N | N | N |
Save Virtual code task | Y | Y | N | N | N |
Delete Virtual code task | Y | Y | N | N | N |
Unpublish Virtual code task | Y | Y | N | N | N |
Submit Virtual code task | Y | Y | N | N | N |
Refresh Virtual code task | Y | Y | N | N | N |
Shift Virtual code task | Y | Y | N | N | N |
Resource, function folder | |||||
View resource, function folder | Y | Y | N | N | N |
Create resource, function folder | Y | Y | N | N | N |
Edit resource, function folder | Y | Y | N | N | N |
Shift resource, function folder | Y | Y | N | N | N |
Delete resource, function folder | Y | Y | N | N | N |
Resource, function | |||||
View resource, function | Y | Y | Y | Y | N |
Create resource, function | Y | Y | N | N | N |
Edit resource, function | Y | Y | N | N | N |
Delete resource, function | Y | Y | N | N | N |
Submit resource, function | Y | Y | N | N | N |
Shift resource, function | Y | Y | N | N | N |
Offline code template | |||||
Create offline code template | Y (does not support enabling shared container) | Y (does not support enabling shared container) | N | N | N |
Edit offline code template | Y (does not support enabling shared container) | Y (does not support enabling shared container) | N | N | N |
Delete offline code template | Y | Y | N | N | N |
Ad hoc query permission list
Permission point | Project administrator | Project developer | Project visitor | Project analyst | General member |
View ad hoc query folder | Y | Y | Y | Y | N |
Create ad hoc query folder | Y | Y | N | Y | N |
Edit ad hoc query folder | Y | Y | N | Y | N |
Confirm ad hoc query folder | Y | Y | N | Y | N |
Delete ad hoc query folder | Y | Y | N | Y | N |
View ad hoc query | Y | Y | Y | Y | N |
Create ad hoc query | Y | Y | N | Y | N |
Edit ad hoc query | Y | Y | N | Y | N |
Save ad hoc query | Y | Y | N | Y | N |
Delete ad hoc query | Y | Y | N | Y | N |
Refresh ad hoc query | Y | Y | N | Y | N |
Shift ad hoc query | Y | Y | N | Y | N |
Execute ad hoc query code | Y | Y | N | Y | N |
Precompile ad hoc query code | Y | Y | N | Y | N |
Format ad hoc query code | Y | Y | N | Y | N |