3004 : User Identification is not authorised

UDA
Enthusiast

3004 : User Identification is not authorised

Hi,

I have just installed demo database on my laptop alongwith Teradata tools and utilities.

When I try to logon to teradata (through SQL Assistant)using demotdat (TDPID) and user01/user01 as username/pwd, I get the message "3004 : User Identification is not authorised".

Could anyone please help to resolve this ?

Thanks.

1 REPLY
Enthusiast

Re: 3004 : User Identification is not authorised

hi,

Check whether the user is valid .....if it is valid then check whether the
user has execute privilage in the macro DBC.TwoPCRule
If the user doesnt have the execute privilage in the macro....u cant
logon using the username ....grant execute privilage...

grant execute on dbc.twopcrule to user01;

I hope now it will work