Visual Basic Crystal Reports - How to set Oracle Session Role while calling Crystal Report XI ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to set Oracle Session Role while calling Crystal Report XI ?

Luqman

2006-03-24, 7:11 pm

For security Reasons, we have created Oracle Application Roles which
activates when our Application starts with the Oracle command: Set role
myRole, and deactivates with the command : Set Role None.

As these are session roles, and login to Crystal Report through Visual Basic
6.0 creates a New Oracle Session, how can I use this Sql command while
calling Crystal Report from VB-6, to grant necessary Privileges to the user
to view the report.

Any idea please ?

I tried following but could not succeed.

With Crrpt.Database.Tables(1)
..ConnectionProperties("user id")=muser
..ConnectionProperties("password")=mpwd
End With

myConn.Execute "Set Role myRole"

But still gets error: Table or view does not exist.

If I login with Admin Password, the Report runs Successfully.

Best Regards,

Luqman

Sponsored Links