Kbase P46446: What field level security is implemented in Progress SQL-92?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/08/2008 |
|
Status: Verified
GOAL:
What field level security is implemented in Progress SQL-92?
GOAL:
How to use the GRANT statement in SQL-92?
GOAL:
How to use the GRANT UPDATE statement to limit what columns / fields a user can update for a table.
GOAL:
How to use the GRANT SELECT statement to limit what columns /fields a user can select for a table.
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The SQL-92 GRANT Statement is used to grant specified privileges to the specified users on the specified objects of the database:
The SQL-92 statements:
GRANT UPDATE (Custnum, name, balance) ON PUB.CUSTOMER TO UserName;
COMMIT WORK;
This statement restricts the user's column level security UPDATE privilege on the Customer table to the named fields only.
CREATE VIEW ViewName (CustNum, Name, Country) AS SELECT CustNum, Name, Country FROM PUB.Customer;
GRANT SELECT ON ViewName TO UserName;
COMMIT WORK;
This statement restricts the user's column level security SELECT privilege on the Customer table to the named fields only.