Can a Revoke or alter user statement be executed on a Session to modify a user's role (set as default) or revoke a role based on whether the uesr logged into a defined list of valid applications versus SQL Plus? I want to set one role if the user connects via an appropriate app and set a readonly type role if the user connects with something else. This is needed to resolve an audit issue.

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions