Disappearing Access Rights

UDA
N/A

Disappearing Access Rights

We had an issue where a user received a 3523 error (The user does not have EXECUTE access...)when attempting to execute a macro that the same user executes several times on a daily basis.

Has anyone experienced temporarily disappearing access rights before? If so, what was the cause? What was the solution?
3 REPLIES

Re: Disappearing Access Rights

One possible reason that I can assume is either someone might have revoked the privilege from the default role that was assigned to this user or role itself might have been revoke.One more possibility might be explicitly revoking the access privilege from the user ID.

query the accessrights tables in dictionary to check what privileges does this user have.

Re: Disappearing Access Rights

I faintly recall there was a teradata bug with similar symptoms... Did you check with GSC ?
N/A

Re: Disappearing Access Rights

Thank you both for your responses.

As the DBA, I did not revoke any privileges (direct or role-related ). I did read something about nested roles having a problem, but that also is not the case in this situation.