Contents
Prev | Up | Next |
Part II. Creating Your Veil2-based VPD Step By Step | Home | Chapter 8. Getting Started With Veil2 (STEP 1) |
Setting up your database to use Veil2
is a
fairly straightforward process, and can be done in the following
steps:
-
install the
Veil2
extension; - identify and define your scope types;
- choose and implement your authentication and session management mechanisms;
- create foreign key links for
veil2.accessors
; - link your scopes and security contexts;
- define your scope hierarchy;
- create an initial set of privileges;
- integrate and/or create roles;
- secure your tables;
- secure your views;
- assign initial roles to users;
- set up housekeeping tasks;
- test
There are a significant number of steps needed to complete your
implementation. To help you track your progress, and determine
which steps have still to be taken, you can call the function
veil2.implementation_status()
.
This function returns records for each step that is still to
be performed. Note that it cannot tell you anything about the
correctness of your implementation; it just
helps you to identify what steps you have not yet begun.
Here is an example of its output, from the demo before step 7 is performed:
implementation_status --------------------------------------------------------- You need to create user scopes (step 7) You need to redefine the superior_scopes view (step 8) The following tables have no security policies: - demo.projects - demo.project_assignments - demo.party_types - demo.parties_tbl (8 rows)