Privileges table returning deleted rows
SummaryAfter deleting functional privileges from a custom job role, when I query the privilege related to the role it still returns a record
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?