Kbase P114737: The _sqlsrv2 process crashes when a non-DBA user tries to query the database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/25/2009 |
|
Status: Unverified
SYMPTOM(s):
The _sqlsrv2 process crashes when a non-DBA user tries to access the database schema
The _sqlsrv2 process crashes when a non-DBA user tries to query the database
The SQL-92 server crashes when a non-DBA user tries to access the database schema
The SQL-92 server crashes when a non-DBA user tries to query the database
The database does not have the Basic collation
Stack trace from _sqlsrv2 on a Windows OS reads:
nlsIsSortNeeded
Stack trace from _sqlsrv2 on a Linux OS reads:
nlsSortKey
auth_tba_getusrperms
auth_check
xec_has_perms
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.1A01 32-bit Service Pack
OpenEdge 10.1A01 64-bit Service Pack
All Supported Operating Systems
CAUSE:
Bug# 20060328-004
FIX:
Upgrade to 10.1A02 or later
Workarounds:
Option #1
A possible workaround is to load the Basic collation for the database. After rebuilding the indexes, the non-DBA SQL user will be able to query the database properly again. You need to be aware that this can change the sort order and result of a query if it is being resolved by a database index.
Option #2
If you are using an ODBC / JDBC reporting tool and only need read-only access to the database, then grant the DBA privilege to the required users and set the connection Isolation Level to Read Uncommitted.