Kbase P126563: Intermittent Access denied (Authorization failed) (7512) error accessing database with default PUB a
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
29/02/2008 |
|
Status: Unverified
SYMPTOM(s):
PUB user experiences intermittently experiences 7512 error
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-20228
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Access denied (Authorization failed) (7512)
PUB user can query the table successfully on some occasions but not others
PUB and SYSPROGRESS user accounts are defaults and are created via Data Administration
No SQL privileges are explicitly assigned to either PUB or SYSPROGRESS users
PUB and SYSPROGRESS connect to the same _SQLSRV2 process
SYSPROGRESS user executes SQL statements that PUB user cannot due to lack of permissions
PUB user gets 7512 error trying to access tables referenced in SYSPROGRESS' query after SYSPROGRESS has executed the SQL statement
PUB user can access tables if they are queried before SYSPROGRESS executes the SQL statement
CAUSE:
Bug# OE00159365
FIX:
Option #1
Upgrade to 10.1C or later
Option #2
Explicitly grant SELECT privileges on tables to the PUB user
Option #3
Separate PUB and SYSPROGRESS users by using 2 brokers; PUB user connecting to one, SYSPROGRESS user the other.