Crystal Report and ODP.Net

Question

We use CR XI at Oralce. We use RLS (Row Level Security) in the database. RLS will be based on the information that we set in the session (by calling trans_pkg.set_username ('abc')) to determine which rows of data can be displayed in the dataset. But CR seems to have its own connection to Oracle. We have no way to run the package, for example: trans_pkg.set_username ('abc') before the CR request data. Now this is a big security threat to our system. If you have any solutions, please help me.

Answer 1

I did not use crystal against oracle, only sql server, but the answer should be the same. When you provide connection information for the report, you need to provide a username and password. The database should use this information to identify the user and assign the correct access rights.

Answer 2

Since you are using Crystal Report Viewer instead of the BO server, you can simply use DataSets, as in this answer

If you used the BO server, you need to create another procedure that first calls the user name and then executes the procedure of the report or query source.