Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smitakale

    Supress password prompt

    Hi, I am writing shell script for creating AIX users. The script takes 'number of users to be added' as the argument and generates the users using 'mkuser' command. But the users are disabled till their password is not set using 'pwdadm' command. The 'pwdadm' command prompts for new password...
  2. smitakale

    command to list all db2 users

    Hi, Is there any DB2 command to - 1. list all DB2 users. 2. list all operating system users. Thanks in advance, Smita.
  3. smitakale

    User Default Character set can not be set to GRAPHIC

    While creating or modifying user, if Character type is set to 'GRAPHIC', it gives error 'The User Default Character Set cannot be GRAPHIC.' Any idea why this is happenning ? Teradata version is V2 R 04.01.02. Thanks, Smita.
  4. smitakale

    Escaping special characters from SQL statements

    Hi, I am facing the problem of escaping single and double quotes in stored procedure am writing for creating teradata user. eg. consider the following statements - 1. SET createUserSQL = 'CREATE USER ' || '"' || erUserName || '"'; In this statement if variable erUserName...
  5. smitakale

    Logging on to Teradata RDBMS without password

    Hi, Thanks for quick response. I tried it that way. But it didn't work. I'll give the details steps I have performed. 1. logged on to BTEQ as administrative user. 1. create user "testuser@domain_name" as perm=10000,password=secret; 2. grant logon on all to testuser with null...
  6. smitakale

    Logging on to Teradata RDBMS without password

    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...

Part and Inventory Search

Back
Top