Kbase P142428: Does OpenEdge have a version of the Procedure Editor to limit user access?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/03/2009 |
|
Status: Unverified
GOAL:
Does OpenEdge have a version of the Procedure Editor to limit user access?
GOAL:
Is user access limited in the Procedure Editor?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.x
FIX:
No, there is no limited edition of the Procedure Editor in Open Edge.
You can limit user permissions by limiting table access in the Data Administration Tool.
It is strongly recommended to ensure there is a valid 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.