Skip to Content
avatar image
Former Member

How to code VB .NET to use schema owner to retrieve and export crystal output to PDF

I have a simple report that connects to Oracle via TNS. The table that it uses is called "A". The Crystal report was created by a user name (and DB owner) "sysadm". Data cannot be retrieved by a user "user1' with password "pwd" that has read access to table via the VB.NET application. Running the application using the "sysadm" credentials the programs works. Running it with user1 credentials the application gives the error "

"Failed to retrieve data from the database." & vbLf & "Details: [Database Vendor Code: 942 ]".

User1 can query table A in a query tool only by prefixing the table with the owner: SELECT ANYCOL FROM SYSADM.A.

So I am assuming my code needs to somehow tell crystal the schema owner.

Any help is appreciated.

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 02, 2017 at 09:04 PM

    Correct, CR fully supports DB security.

    Try searching first before posting, lots of posts on how to use CR API's to set log on info. - SetTableLocation

    Don

    Add comment
    10|10000 characters needed characters exceeded