I am running a script via loadercli to create the database schema and create the user accounts. I came across a very strange behavior of "create user"

The script originally was as follows:

/* Create Users */
CREATE USER be_app PASSWORD be_app
//
CREATE USER be_xx PASSWORD be_xx
//
CREATE USER be_yy PASSWORD be_tyy

etc.

It failed on the first line telling me that the user name is invalid. I changed the user name in the first line to BE_APP (i.e. changed it to upper case) and suddenly the whole script worked. Why would the upper case name requirement exist only on the first line? Or was is a different problem?

Avi
--
Avi Schwartz
[EMAIL PROTECTED]

''You can turn painful situations around through laughter. If you
can find humor in anything, even poverty, you can survive it.''
- Bill Cosby

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to