Kbase P24078: How to re-activate Blank Userid Access ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/4/2009 |
|
Status: Unverified
GOAL:
How to re-activate "Blank Userid Access" ?
GOAL:
How to revert "Disallow Blank Userid Access" ?
FIX:
There is no direct way (menu, button, option) how to do it.
However, there is one possibility - using 4GL query, which will change securiy in hidden metaschema tables, but please note this is not supported by Progress Software and backup of database before running the query below is recommended.
The "disable blank userid access" does following thing, it will put "!" to the can-read,write,create,delete tables security - which means "no blank users have access to them"
Following query modifies the tables security back to "enabled to all". If you already have some level of security (user access) implemented within your database, you might want to replace "*" with string including users belong to your database.
FOR EACH _file WHERE _file-num > 0 AND _owner = "PUB":
ASSIGN _file._CAN-READ = "*"
_file._CAN-WRITE = "*"
_file._CAN-CREATE = "*"
_file._CAN-DELETE = "*".
END.