Kbase P11322: Where in the database is table security information stored?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/02/2010 |
|
Status: Verified
GOAL:
Where in the database is table security information stored?
GOAL:
Where are table permissions stored when entered through the Data Administration tool's "Edit Data Security" option
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
Table and Field permissions information are stored in _file or _field records for each table/field in the database in the _can-read, _can-write, _can-create, _can-delete, _can-dump & _can-load fields. To display lists of who has access to which tables execute the following code:
FOR EACH _File NO-LOCK:
DISPLAY _can-read _can-write _can-create _can-delete _can-dump _can-load.
END.