Ensure SSRS sessions are readonly to Oracle databases.

Hi,

I am looking at ways of ensuring that anyone who logs onto the database (oracle 12c Standard Edition) using the SSRS reporting tool is automatically logged on as readonly so no DML is allowed.

Is this possible?

I was looking at onlogon triggers but I am not sure if the logon trigger can first recognize using sys_context that the module is SSRS and then run an alter session readonly.

Does the user logging in need the alter session privilege or will this run as the owner of the trigger (SYS for instance)?

Am I barking up the wrong tree here and is there a better way of ensuring any sessions via SSRS are readonly.