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

Privileges table returning deleted rows

Accepted answer
19
Views
1
Comments
edited May 12, 2020 8:34PM in HCM Integrations 1 comment

Summary

After deleting functional privileges from a custom job role, when I query the privilege related to the role it still returns a record

Content

Is there a way to remove the privilege row (end date, active flag, etc) from either the ASE_Priv_Role_MBR -> ASE_PRIVILEGE_B table after it has been removed from the associated role? I am still seeing the privileges I removed from the specified role, but it shouldn't be associated with the role. Is there another table that stores privileges that can be joined to the role table?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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