Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.  



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