Within the SeRP environment once a project space is created and data ingested or provisioned. a specific project schema is created this is the name of the project.
Should users wish to create objects within that schema, either tables or views of that underlying data. Then they can do this by creating separate tables or views from that original project data and sharing that for all permitted users of that project.
SeRP has a permissions based model that implements stated permissions controlled by SeRP every hour. Once an object is created it could take up 2 hours for this to be present to all users,
Note: This user guide is intended for all SeRP users but each implementation may differ and you may not be provided with appropriate permissions to carry out this activity.
Step-by-step guide
Pre Requisites:
- Users will require rw permissions on the database within a project.
How to configure:
- Any object (Views/Table/Queries etc) will need to be prefixed with the name of the project followed by a full stop
- In the example below the project name is Restricted. Therefore if a view was generated for this project the action would be
"create view restricted.joinoftables"
3. Once created this will be for users with r or rw access to the project database schema.