Kbase P97685: Client displays error (3142) after Blank User ID's were disabled in the database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2010 |
|
Status: Verified
SYMPTOM(s):
Error (3142) is displayed on client screen.
You do not have sufficient permission to increment sequence values. (3142)
Blank User ID's are disabled within database security.
FACT(s) (Environment):
All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
CAUSE:
The user does not have permission on the _sequence table to read the sequence values.
FIX:
1. Provide to the user the permission on the _Sequence table to read a sequence value. You do this through the Data Dictionary on UNIX, or the Data Administration tool on Windows.
On UNIX:
a) pro dbname -p _dict.p
b) Admin / Security / Edit Data Security menu.
c) When it asks for the table name, Enter "_sequence" without the quotes.
d) Change the _sequence schema as appropriate.
On Windows:
a) Data Administration tool.
b) Connect to your database.
c) Admin / Security / Edit Data Security menu.
d) Tick the "Show Hidden" toggle box.
e) Select the _sequence table.
f) Change the _sequence schema as appropriate.
2. Make sure that the database connection statement has the -U -P parameters and values.