Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 01 Aug 2002 @ 08:00:44 GMT





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




Subj:   Re: Convert DATABASE to USER
 
From:   Dieter Nöth



Hi Mats

  does anybody of you know if it is possible to convert an existing DATABASE to a USER?  


Impossible, maybe if you bypass access rights, but IMHO this is of course unsupported and much to dangerous. I tried it about a year ago on the demo version, updated dbc.Dbase with an existing password, tried to logon and crashed the system (maybe because i forgot to update RowType to 'U', but i didn't want to investigate it further). You probably don't want to do that on your production system ;-)


  It seems that if you want to use DDL commands in SPL you have to create the stored procedure in the creating users own database.  


Yo

Dieter





     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008