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
