 |
 |
Archives of the TeradataForum
Message Posted: Thu, 01 Aug 2002 @ 08:00:44 GMT
| 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
| |
