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
