Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What causes the ACTIVE_FLAG field in PER_USER_ROLES to be set to "N"?

in Applications Security 4 comments

When a role is deleted from a user, that role is almost always deleted from the PER_USER_ROLES table. When querying the table, I noticed that a few rows exist where the ACTIVE_FLAG is set to "N". Our auditors want to know what causes this flag to be set to "N" instead of being deleted.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!