How to set logging level for the users in obiee security using Extrenal table authentication

a) Today i have a requirement to setup logging levels for users.If we are using rpd level security then it very simple just we need to change the log level in rpd for every user

b) But,in case of External table authentication it was quite different for this we have to create session variable for that firstly create one initialization block in that use the following query select 2 "LOGLEVEL" from DUAL

where 2 is logging level for all the users

c) Create one session system variable with LOGLEVEL as its name and assign the above defined initialization block to this variable LOGLEVEL