All Forums UDA
JustMe 76 posts Joined 03/07
30 Jan 2008
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?

leo.issac 184 posts Joined 07/06
30 Jan 2008

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.

joedsilva 505 posts Joined 07/05
30 Jan 2008

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

JustMe 76 posts Joined 03/07
01 Feb 2008

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.

You must sign in to leave a comment.