Archives of the TeradataForum

Message Posted: Wed, 30 Dec 2015 @ 06:53:01 GMT

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

Hi ,

I have changed the passwordRestrictWords value to Yes in dbc.syssecdefaults. The RestrictedWords contains a list of character values.

I tried to create a user with password as one of the value in RestrictedWords list. What I expect is the user should not get created and error should be reported. But in my case, the user is getting created.

     BTEQ -- Enter your SQL request or BTEQ command:
     sel * from dbc.syssecdefaults;

     sel * from dbc.syssecdefaults;

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

     PrimeIndex  ExpirePassword  PasswordMinChar  PasswordMaxChar PasswordDigits  PasswordSpecChar  PasswordRestrictWords
           MaxLogonAttempts                LockedUserExpire
             PasswordReuse
     ----------            --------------                     ---------------
     ---------------                   --------------
                    ----------------                 ---------------------
                       ----------------
                                ----------------                   -------------
              1                             0
                     1                                        127
                                Y
                             Y
                                           Y
            0                                                       0
                                                 0

     BTEQ -- Enter your SQL request or BTEQ command:




     sel * from dbc.passwordrestrictions;

     sel * from dbc.passwordrestrictions;

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

     RestrictedWord
     ------------------------------
     xxxxx
     TOWN
     WHAT
     DEGREE
     OBVIOUSLY
     ASPECTS
     DOG
     DOLLARS
     CAUSED
     MICHAEL
     TYLER
     NECESSARY
     EXISTENCE
     EXISTING
     RESPONSIBLE
     DEATH
     SIGHT
     ROBIN
     .
     .
     .
     .
        etc.


     BTEQ -- Enter your SQL request or BTEQ command:
     create user shankar as perm=1000,password=xxxxx;

     create user shankar as perm=1000,password=xxxxx;

     *** User has been created.
      *** Total elapsed time was 1 second.


     BTEQ -- Enter your SQL request or BTEQ command:

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