What is purpose of USER ALL in teradata

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Enthusiast

What is purpose of USER ALL in teradata

what is purpose of user ALL in teradata ? Is it created with the init script along with other system users. should this user have access on application databases ?

1 REPLY
Senior Apprentice

Re: What is purpose of USER ALL in teradata

Hi Imran,

 

Yes it is created as part of 'system setup' along with the other users.

No, that user does not need access to any application databases or objects.

 

Note that you will also see (returned from some system views) table and column names of 'All'. These are just used ot simplify reporting of various items. For instance if an AccessRight applies to Tablename = 'All' then it is an AccessRight at the database level.

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com