Hi,
I performed following steps for granting user logon with NULL password on Network attached system -
1. Created Administrative user with EXECUTE permission on macros DBC.AccLogRule and DBC.LogonRule.
2. Created user 'testuser' using this Administrator with temporary password.
3. Granted logon with NULL PASSWORD to this user using st - GRANT LOGON ON ALL to testuser WITH NULL PASSWORD;
4. Tried to log on using 'testuser' without password through BTEQ, WinDDI, queryman and WinSQL utilities.
But its not working.
Can someone tell me if i missed some step. Or something else is to be done for granting user null password privilege.
Teradata RDBMS I am using is Version 2 Release 4.01.02. and Teradata client is TUF 6.1.1.
Any help in this regard will be highly appretiated.
Thanks,
Smita.
I performed following steps for granting user logon with NULL password on Network attached system -
1. Created Administrative user with EXECUTE permission on macros DBC.AccLogRule and DBC.LogonRule.
2. Created user 'testuser' using this Administrator with temporary password.
3. Granted logon with NULL PASSWORD to this user using st - GRANT LOGON ON ALL to testuser WITH NULL PASSWORD;
4. Tried to log on using 'testuser' without password through BTEQ, WinDDI, queryman and WinSQL utilities.
But its not working.
Can someone tell me if i missed some step. Or something else is to be done for granting user null password privilege.
Teradata RDBMS I am using is Version 2 Release 4.01.02. and Teradata client is TUF 6.1.1.
Any help in this regard will be highly appretiated.
Thanks,
Smita.