Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 06 Dec 2010 @ 21:22:06 GMT


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


Subj:   Re: Cloning SYSDBA user
 
From:   John_Wight

OK - if you use the dbc.User view, you can get all the 'parameters' that are used/displayed in the TD Admin Clone User function I referenced in my previous response. From this you can generate the CREATE USER . . . DDL and execute it in the SPL or even macro.

Hope this helps.


     SELECT
             UserName
             ,OwnerName
             ,PermSpace
             ,SpoolSpace
             ,TempSpace
             ,DefaultAccount
             ,StartupString
             ,ProtectionType
             ,JournalFlag
             ,DefaultCollation
             ,DefaultCharType
             ,DefaultDateForm
             ,TimeZoneHour
             ,TimeZoneMinute
             ,ProfileName
             ,RoleName
     FROM
             "DBC".Users
     WHERE
             username = '';

JK Wight
EDW - Integration/DBA



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023