Kbase P19093: How to implement Row Level Security with SQL-92 ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/20/2009 |
|
Status: Verified
GOAL:
How to implement Row Level Security with SQL-92 ?
GOAL:
Is row level Security implemented in SQL-92 engine?
GOAL:
How to create a view to limit user access to certain rows?
FACT(s) (Environment):
Progress 9.x
All Supported Operating Systems
OpenEdge 10.x
FIX:
At the current state of Progress SQL-92, row level security is not implemented in the Engine.
As an example, let's assume, you would like to prevent "user1" to NOT be able to select rows that have 'City = 'Paris' from the Table called 'Employee' (the same user is allowed to select rows that are different to 'Paris')
See the following example that demonstrate the case:
create view myView as (select * from Employee where city <> 'Paris');
grant select on myView to 'user1';
commit;