Archives of the TeradataForum

Message Posted: Sat, 02 Jan 2016 @ 07:41:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi,

I have executed the following command on a user.

     revoke logon on 1 to shankar;

when I query the LogonRulesV view I got the following output.

     select
     username(varchar(20)),logicalhostid(varchar(20)),logonstatus(varchar(20)),nu
     llpassword,
     creatorname(varchar(20)) from logonrulesv where username in ('shankar');

      *** Query completed. 3 rows found. 5 columns returned.
      *** Total elapsed time was 1 second.

     UserName      LogicalHostID  LogonStatus  NullPassword
     ------------  -------------  -----------  ------------
     shankar          1           G            F
     shankar          0           G            T
     shankar       1024           G            T

Here in the LogicalHostID column I found additional 2 entries as 0 and 1024.

Is HostID 0 for console session? what is 1024 for?

2) Also, I tried to grant to grant the logon to user with null password. But that is not working. I have updated the syssecdefaults view too. I have changed the passwordminchar to 0.

When I tried to create a user with no password, it is prompting me an error that an user needs an password to logon.

how can I create a user with null password/how can I login to DB with a null password. Here is what I did.

      BTEQ -- Enter your SQL request or BTEQ command: grant logon on 1 to shankar with null password;

     grant logon on 1 to shankar with null password;

      *** Logon has been granted.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your SQL request or BTEQ command:



     TDExpress14.0.3_Sles10:~ # bteq .logon 127.0.0.1/shankar,,;

      Teradata BTEQ 14.00.00.05 for LINUX.
      Copyright 1984-2012, Teradata Corporation. ALL RIGHTS RESERVED.
      Enter your logon or BTEQ command:

      .logon 127.0.0.1/shankar,
      *** Failure 8017 The UserId, Password or Account is invalid.
      *** Error: Logon failed!

      *** Total elapsed time was 1 second.

      Teradata BTEQ 14.00.00.05 for LINUX. Enter your logon or BTEQ command:




      BTEQ -- Enter your SQL request or BTEQ command:
     update syssecdefaults set passwordminchar=0;

     update syssecdefaults set passwordminchar=0;

      *** Update completed. One row changed.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your SQL request or BTEQ command:
     sel passwordminchar from syssecdefaults;

     sel passwordminchar from syssecdefaults;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

     PasswordMinChar
     ---------------
                   0

      BTEQ -- Enter your SQL request or BTEQ command:
     sel date;

     sel date;
      *** Error 2825 NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC RESTART
      *** Total elapsed time was 1 second.


      *** Warning: Attempting to resubmit last request.

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

         Date
     --------
     16/01/02

      BTEQ -- Enter your SQL request or BTEQ command:
     create user pk as perm=1000 ;

     create user pk as perm=1000 ;

     create user pk as perm=1000 ;
                                 $
      *** Failure 3797 A PASSWORD must be specified when creating a user.
                     Statement# 1, Info =29
      *** Total elapsed time was 1 second.

	<Prev	Next>		<<First	<Prev	Next>	Last>>