cancel
Showing results for 
Search instead for 
Did you mean: 

Table: [tblUsers] - I Updated the "Active" Column from "Yes" to "No" - Can Still Access BPC

0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member186498
Active Contributor
0 Kudos

Hi Barry,

a possibility is to create a new task profile without tasks and assigning it to the user you want to block same thing for the member access profile.

Another possibilty is to create history tables with the same structure of the security tables (user, teams, task, map...) adding eventually also a start and end date and maintaing these manually (delete from standard tables and insert into history tables).

Regards

     Roberto

0 Kudos

Hi Roberto,

Thanks for the reply. I do understand the approach that you’re describing. This may be a last option for us to attempt.

What I’d still like to solution is how to update the Active status in the tblUsers table. Whenever a new user is added to BPC, the profile is displayed in this table. And the Active status is set to “Y” .

What I don’t understand is, how, or can this column property be updated via a process in BPC? We updated it via SQL but it had no effect on user access.

Thanks again for your reply. Barry

Table: TblUsers

UserIDFullNameDomaineMailPasswordHashRoleIDLanguageActiveIMAccountIMTypeUniqueID
Company\xxxxxxxx zzz.xxx@yyyy.net 0 Y 0Company\xxxx
Company\yyyyaaa,bbbNULLaaa.bbb@yyyy.net NULLNULLY 0Company\yyyy
former_member186498
Active Contributor
0 Kudos

Hi Barry,

updating via SQL the active field is the only possibility you have but you're right saying it doesn't work, the first time you change or insert one user in the admin console the active status of all user become 'Y'.

I think this field is not intended for your purpose but when you copy or restore an appset you have all users disabled only the sysadmin works so you're able to do the checks and activities you need before to open the appset to other users.

That's why I suggest the other options.

Regards

     Roberto