Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

SQL Used:
Update dbo.tblUsers
Set Active = 'N'
where UserID = 'XXXX'

Previous SAP Note numbers reviewed 1580854 and 1299169

Former Member
Not what you were looking for? View more on this topic or Ask a question