Kbase P8512: How do I exclude users permissions on multiple tables?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2008 |
|
Status: Verified
GOAL:
How do I exclude user table permissions on mutliple tables?
GOAL:
How to set database security so that some users cannot access tables?
GOAL:
How to modify the user permissions on tables ?
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Product Family
FIX:
It is strongly recommended to ensure there is a vaild database backup before proceeding.
The following 4GL script will update all the _file table, which holds table permissions:
FOR EACH _file WHERE _file-num > 0 AND _owner = "PUB":
ASSIGN _file._CAN-READ = "!p*,*"
_file._CAN-WRITE = "!p*,*"
_file._CAN-CREATE = "!p*,*"
_file._CAN-DELETE = "!p*,*"
_file._CAN-DUMP = "!p*,*"
_file._CAN-LOAD = "!p*,*".
END.
# that's every-one except users beginning "p" have permission.
Using the "!" character before the user name will exclude that user.
Don't forget to include the "*" at the end for the remaining users.