Error: Falied to open the rowset Details: HY000:[DataDirect - Technologies][DBC Progr

A

alfiee

New Member
Hello All,


Am getting this error when I try to access a progress database through power builder or crystal reports.

Error: Falied to open the rowset Details: HY000:[DataDirect - Technologies][DBC Progress driver][PROGRESS]Accesss denied(Authorisation failed)


However i can view the table structure but no data can be selected.


need some help with this one
 
Hi.

you have to grant access rights to the user.

Example.

GRANT SELECT ON Table1 To User1

To do this you have to connect with a user who has Admin Rights.

To check DBA / Resource privileges in use, execute the following SQL
statement in the SQL explorer:
SELECT * FROM sysprogress.sysdbauth;

Look for the user who has DBA privileges or you could try using the
user: sysprogress

Hope this helps.
 
Hello marca,

I got a dba with admin rights to grant me access to the tables needed but I still get the same error.

Am using Progress 9.1D.

the security for each and every table to query is set to
Can-Read: *
Can-Write: *
Can-Create: *
Can-Delete: *
Can-Dump: *
Can-Load: *


the version of driver for ODBC connection is MERANT 3.60 32-BIT Progress SQL92v9.1D


would need further help
 
Hi.

To check Table/View/Synonyms/SQL-92 Stored Procedure privileges in
use, execute the following SQL statement :

SELECT * FROM sysprogress.systabauth;

look at the value of the SEL column for each table. It should be something like this.

GRANTOR GRANTEE TBLOWNER TBL ...SEL...
sysprogress user1 sysprogress table1 ...Y...

"Y" value in column SEL means the user user1 has select right for table table1

Post your results.
 
You must log in or register to reply here.
Back
Top