this command has worked on my SAP DB:
create user ASDF password ASDF standard not exclusive
HTH Andreas
Reimund K�hler schrieb:
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
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
