Kbase P50497: 4GL code to display SQL Grantors' / Grantees' privileges for all tables tables in a database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/31/2008 |
|
Status: Verified
GOAL:
4GL code to display SQL Grantors' / Grantees' privileges for all tables tables in a database.
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
The following code will list all Grantors' / Grantees' and associated SQL access rights for all tables in the database.
CURRENT-WINDOW:WIDTH = 140.
FOR EACH _systabauth.
DISPLAY _Grantor _Grantee _Tbl _Upd _Sel _Ndx _Alt _Ref WITH WIDTH 140 .
END.