Table: [tblUsers] - I Updated the "Active" Column from "Yes" to "No" - Can Still Access BPC
Hi BCP Community,
Re: Updating the tblUsers table via the BPC Application 7.5 Microsoft
We have user profiles in BPC 7.5. Per SOX, we do not want to delete their profiles. We updated the tblUsers table, column Active from "Y" to "N" via SQL. The user logged off and back on to BPC. The User was still able to access the BPC Application. We re-started IIS and SendGovernor prior to the user logging back-on to the BPC, Excel plugin. Still no success.
Besides removing a user from selected Teams, is there a way to update his/her status in BPC, automatically update the table and disable no-longer-employed users?
Thank you. Barry
Steps for Reconstruction
Set Active = 'N'
where UserID = 'XXXX'
Previous SAP Note numbers reviewed 1580854 and 1299169