Kbase P144444: Linked table to MS Access giving error 7512 when trying to read records with non existing user with
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/04/2009 |
|
Status: Unverified
SYMPTOM(s):
Linked table to MS Access giving error 7512 when trying to read records with non existing user with no privileges to the database's pub schema
Access denied (Authorization failed) (7512)
FACT(s) (Environment):
User used to log in is root which does not have select privilege on any pub schema tables
The database owner is a different user than the root
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The user root does not have any privileges on the pub schema tables
FIX:
To verify the correct owner of the database, use the following steps. After the database owner is found, use the database owner with a fake password to connect to the database using ODBC deriver connection.
1. Start > Programs > progress > proenv on Windows or go the $DLC/bin on UNIX
2. On the prompt, type the following and press enter:
sqlexp -db <my_db> -S <port#> -H <host name or IP address> -user root -password x
The character sql explorer will connect to the database using JDBC
3. Use the following sql to look at the default database owner other than sysprogress on the sysdbauth view:
select * from sysprogress.sysdbauth;
the above query will display two DBA users - one is the owner and another one is sysprogress.
Use the first user other than sysprogress to connect to the database using the MS Access or MS Excel to see if you can see the records. The password can be used as "x' without the double quotes.