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.
-
Interview Candidate
- Apr 17th, 2006
- 0
- 2108
This Question is not yet answered!
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!