Kbase P3965: 4GL/ABL: Is it possible to set the database 'Disallow Blank Userid Access' setting programatically?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/2/2010 |
|
Status: Verified
GOAL:
4GL/ABL: Is it possible to set the database 'Disallow Blank Userid Access' setting programmatically?
GOAL:
How to disallow Database Blank Userid Access using 4GL/ABL?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
To programmatically 'Disallow Blank Userid Access' to a Progress Database, create, programmatically or through the database data administration tool, at least one database user and before running the following code.
FOR EACH _File NO-LOCK WHERE _Tbl-Type = "T"::
ASSIGN
_can-create = "!,*"
_can-write = "!,*"
_can-read = "!,*"
_can-delete = "!,*".
END.
The 'Disallow Blank Userid Access' action sets the _can-read, _can-write, _can-create, and _can-delete fields values to "!,*" which indicates that blank userids can not access the database tables.