Arne,
you are right. SQLMode was ANSI. Now it works.
Thanks to all!
Regards Reimund
----- Original Message -----
From: "Arne Gehlhaar" <[EMAIL PROTECTED]>
To: "Reimund K�hler" <[EMAIL PROTECTED]>
Cc: "Anhaus, Thomas" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, March 04, 2003 2:42 PM
Subject: Re: create user fails
> Raimund,
>
> are you sure you are using INTERNAL SQL mode? This command does not work
> in ANSI mode!
>
> Arne
>
> Reimund K�hler wrote:
> > Thanks for the answer, but the command
> >
> > create user ASDF password ASDF
> >
> > (without '') produces the same error message ("Syntax error or access
> > violation;-5015 POS(8) Missing keyword:OR.").
> >
> > The database has been setup with the database manager. I am using the
SYSDBA
> > user defined when creating the database.
> >
> > Regards Reimund
> >
> >
> >
> > ----- Original Message -----
> > From: "Anhaus, Thomas" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Tuesday, March 04, 2003 10:55 AM
> > Subject: RE:create user fails
> >
> >
> > Reimund K�hler wrote :
> >
> >
> >>Hi,
> >
> >
> >>I'm trying to create a new user from SQL Studio:
> >>create user ASDF password 'ASDF'
> >
> >
> >>All I get is "Syntax error or access violation;-5015 POS(8) Missing
> >>keyword:OR."
> >
> >
> >>What's wrong?
> >
> >
> > The password must be an identifier, not a string literal, i.e.
> >
> > create user ASDF password ASDF
> >
> > should work.
> >
> > Regards,
> > Thomas
> >
> > --
> > Thomas Anhaus
> > SAP DB, SAP Labs Berlin
> > [EMAIL PROTECTED]
> > http://www.sapdb.org/
> > _______________________________________________
> > sapdb.general mailing list
> > [EMAIL PROTECTED]
> > http://listserv.sap.com/mailman/listinfo/sapdb.general
> >
> >
> >
> >
> > _______________________________________________
> > sapdb.general mailing list
> > [EMAIL PROTECTED]
> > http://listserv.sap.com/mailman/listinfo/sapdb.general
> >
>
>
> --
> Institute of Shipping Economics and Logistics http://www.isl.org/
> Arne Gehlhaar mailto:[EMAIL PROTECTED]
> Universitaetsallee GW1 Block A phone:+49.421.22096.49
> D-28359 Bremen, Germany fax:+49.421.22096.55
>
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
