Crystal Report and ODP.Net

We are using CR XI on Oralce. We applying RLS (Row Level Security) in DB. RLS will base on information we set in the session (by calling 开发者_如何学编程 trans_pkg.set_username('abc')) to decide which data rows can appear in dataset. But CR seems to have its own Connection to Oracle. We have no way to run a package like: trans_pkg.set_username('abc') before CR query data. It is now the big security risk to our system. If you have any solution please help me.

I have not used crystal against oracle, only sql server, but the answer should be the same. When you set thwe connection info for the report, you need to specify the user name and password. The database should use this info to identify the user and assign correct access permissions.

Since you're using the crystal report viewer instead of a BO Server you can just use DataSets as in this answer

If you were using a BO Server you'd need to create another procedure that first calls sets the user name and then execute the report source procedure or the query.