feat(#23) working example of how rls can be implemented

[HknLof]

This is a follow up to pull request https://github.com/DataCater/datacater/pull/77. The process to implement RLS for datacater is as follows:

1. Initialise tables and user role datacater via migartions. For now init-db.sql.
2. Define a @MappedSuperClass, which fills in the tenant automatically. [Static for validating approach]
3. On Read queries set the current tenant as a pg param via SET datacater.tenant = $tenant. [Static for validating approach]

Refs

• https://github.com/DataCater/datacater/pull/77

[sonarcloud[bot]]

Kudos, SonarCloud Quality Gate passed!   

0 Bugs
0 Vulnerabilities
0 Security Hotspots
0 Code Smells

84.0% Coverage
0.0% Duplication