Home Page for the TeradataForum
 
https:

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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020