Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 3 hours for this to be present to all users, 

...

  1. Users will require rw permissions on the database within a project. 
  2. There is a mixed estate on how schemas are named, they are either named following the project name or the SeRP tenancy AND the project name. To clarify which pattern you'll need to use when saving your object, you'll need to check the schema name created.
  3. The screenshot below is from SQL Management Studio where you can see the pattern in this example is dsbtraining_cambridge DSB being the SeRP Name and training_cambridge being the Project name.

Image Added

How to configure:

  1. Any object (Views/Table/Queries etc) will need to be prefixed with the name of the project followed by a full stop 
  2. 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"

...

Info
Once an object is created it could take up 2 3 hours for this to be present to all users, 

...

Page properties
hiddentrue


Related issues