Archives of the TeradataForum

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

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

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