Kbase P188413: Disallowed blank userid and after reallowing it get error 3142
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/05/2011 |
|
Status: Unverified
SYMPTOM(s):
Disallowed blank userid and after reallowing it get error 3142
You do not have sufficient permission to increment sequence values. (3142)
FACT(s) (Environment):
There are no users entered in the database Security Administration
All Supported Operating Systems
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
CAUSE:
Not all tables have been given * for permissions.
FIX:
The following code will address the issue (run it in the procedure editor):
FOR EACH _file WHERE (_file._tbl-type = "T" OR
_file._tbl-type = "S") and
_owner = "PUB":
ASSIGN _file._CAN-READ = "*"
_file._CAN-WRITE = "*"
_file._CAN-CREATE = "*"
_file._CAN-DELETE = "*".
END.