AnsweredAssumed Answered

Access Details for Deleted/Terminated User

Question asked by Amit Khatua on Apr 17, 2018
Latest reply on May 22, 2018 by Amit Khatua

Like • Show 0 Likes0
Comment • 2

Hello experts,

Just found that PV_USER_ALL_ACCESS doesn't contain access details for the deleted users and for the users whose account is disabled in particular application. Is not below are valid requirements -

1. Terminated users having access tagged to them for an application (even if the account is disabled in that application)

2. Deleted users having access tagged to them for an application (irrespective of the account is enabled/disabled)

Any clue on any views/tables can help us on this.

We are in VIA 7.0.2 P05.

Thanks, Amit

No one else has this question

Outcomes

2 Replies

Boris Lekumovich Apr 26, 2018 2:41 AM
Mark Correct
Correct Answer
The PV_USER_ALL_ACCESS view is using the following condition: DELETION_DATE IS NULL
```
SELECT ID FROM T_MASTER_ENTERPRISE_USERS where ID > 0 AND DELETION_DATE IS NULL
```
Like • Show 0 Likes0
Actions
- Amit Khatua @ Boris Lekumovich on May 22, 2018 9:13 AM
  Mark Correct
  Correct Answer
  Hi Boris,
  But how can we get the access/account tagged to the deleted users ? Cant see PV_USER_DIRECT_ENTITLEMENT showing these results too
  Like • Show 0 Likes0
  Actions

Access Details for Deleted/Terminated User

Outcomes

Related Content

Recommended Content