Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Dec 2013 @ 11:15:21 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Description or Purpose of System Users in
From:   Bodla, Sravan Kumar

Hello Forum,

Looking for some description/purpose on system users.

As per my knowledge, I have updated the purpose of few users, please correct if wrong.

     System Users    Purpose

     DBC             Super User

     CRASHDUMPS      Will be useful when abrupt restarts occur in the system

     DEFAULT         ?

     PUBLIC          Teradata grants SELECT privileges on system tables to
                     PUBLIC by default.?? And by assigning this PUBLIC to end
                     users they get access on system tables.

     SYSADMIN        ?

     SYSDBA          User for DBA activities

     SYSTEMFE        Field Engineers

     SYS_CALENDAR    ?

     TDPUSER         User used for client connections

     TDWM            Work Load management User

     PDCRACCESS      ?

     PDCRADMIN       Which is used to create objects in PDCR databases and
                     run macros

     PDCRCANARY0M    ?

     PDCRCANARY1M    ?

     PDCRCANARY2M    ?

     PDCRCANARY3M    ?

     PDCRCANARY4M    ?

     PDCRTPCD        ?

Thanks in advance!


EMEA ? Technical Consultant

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