Re: Designer 2.1 1 query

Robin,

[Quoted] I don't quite understand your last point. When you generate the table from the designer, and you select the radio button "Database" you can specify any other user for which the generated scripts are to run. This user will then be the owner of the table.

Robin Quasebarth wrote:

> The way I do it is log into SQLPlus as the user that you want to own all
> objects and run the scripts from there. Really would be nice to have
> the option within Designer to specify a schema if it differs from the
> user designing the db. rq
>
> Derek Mitchell wrote:
>
> > Is anyone using Designer 2.1.1 to generate build scripts?
> > I'd like to be able to produce
> >
> > create table user.table
> >
> > rather than
> >
> > create table table
> >
> > but I don't see how this can be done.
> >
> > Regards,
> >
> > Derek

--
******************************************************************
***** A L C A T E L  B E L L  S P A C E  &  D E F E N S E  *******
Herman Viaene
Berkenrodelei 33, B-2660 Hoboken, Belgium
Tel: (32/3)8295591
Fax: (32/3)8295502
OIS-mail: viaeneh_at_AM_at_BTMA97
Internet-mail: viaeneh_at_btmaa.bel.alcatel.be
X400: Viaene Herman (C=BE,A=RTT,P=ALCANET,OU1=BELA1,O=ALCATEL,
S="Viaene",G="Herman")
******************************************************************