Archives of the TeradataForum

Message Posted: Wed, 01 Nov 2006 @ 19:53:51 GMT

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

<-- Anonymously Posted: Wednesday, November 01, 2006 14:50 -->

Thanks for anomy reply.

I checked Database Administration manual.

     Ref: Database Administration
             Release V2.R6.0
             B035-1093-064A
             Page. No. 128

As per this manual while creating new USER if we are NOT assigning any Account String explicitly then USER will take it default account as first account string from assigned profile.

We are using below DDL structure to create users

     CREATE USER "" FROM ""
     AS PERM = 0
             PASSWORD = 
             PROFILE="";

So as per document USER has to get default account as profile's account. But when I am checking DBC.Databases, I can see it is different account string than it's profile. It is using correct account string (which is there in profile) in DBQL and AMPUsage. Can anybody tell me why this is taking different account strings? Do we need to fix any DBS parameter to make both these ASE in sync? Where system will use Account name from DBC.Databases? What will be negative impact if I make default account as NULL or ' ' (BLANK)?

Thanks in advance if anybody clarify these questions.

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