How to establish "set role all" for each session automatically

[Karthi S]

Hello there,

I joined in a company where the user name I use to connect to the database has "select catalog role" granted with no default option.

so every time, before I execute some SQLs that uses some DBA_ objects, I first need to execute "set role all" for each window (as i use multiple connections option).

Is there any way that I can configure in PLSQL developer? so that every time when PLSQL developer creates new session, it automatically executes "set role all" command while opening a new SQL window or session browser?

Thanks,
Karthi.

 

[lost]

Look into Manual.pdf documentation then AfterConnect.sql and Login.sql scripts.