Worldsoft Documentation Search

Application Roles – Row Level Security

1.2.0.1 July 31, 2019
System Roles

User Roles Security Level (Lower Means More Access) Notes
Site Admin 3 This is the site administrator. It can access all user pages/data
Power User 4 By default, has the same security as the site administrator except it does not have access to all pages in administration tab
Data Analyst 5 The data analyst can access all cost centres
Manager 6 Has access to only cost centres assigned by the site administrator
Data Entry 7 General User. Specified cost centres by the site administrator.
Reporting Only 10 Read only user. Has access to specified cost centres by the site administrator

Row-Level Security Rules

Type Of Row-Level Security Notes Applies To What Security Levels Applies To What System Roles
Security Levels If there is a Security Level column or Edit Security Level column in a table this could affect it’s visibility or ability to edit.  Affects any user whose security level is greater than the one in the column ALL ALL
Roles Same logic as the Security Level columns (listed above) ALL ALL
Cube Groups Limits the cube groups that can be seen 5 and Higher Data Analyst and Higher
Cost Centres Limits the Cost Centres that can be seen 6 and Higher Manager and Higher
Include or Exclude Secondary Accounts Include or Exclude logic specified in the User Maintenance screen. 6 and Higher Manager and Higher
Dash Boards Security can be assigned on the Dash Boards themselves (security level). See notes See notes
Cubes Security can be assigned on the Cubes themselves (security level).  Cube Group security is also taken into account to see what cubes are visible. See notes See notes