Stoedtler, Mathias wrote: > > Hello, > > Is there a way to create a user in SQLMode=Oracle and set the NOT > EXCLUSIVE Option? > > CREATE USER myUsername PASSWORD myPassword RESOURCE NOT > EXCLUSIVE > > works fine in INTERNAL mode. > > CREATE USER myUsername IDENTIFIED BY myPassword RESOURCE NOT > EXCLUSIVE > > also works, but trying to connect twice with two at one time does not > work then. >
The NOT EXCLUSIVE option will only work in internal mode. As we say: we are compliant to an older Oracle-version, especially compliant to statements used in applications. The create user statement is accepted, but several options in the end not read/ignored. In your case, the RESOURCE NOT EXCLUSIVE is ignored, therefore the behaviour you saw, is exactly the expected and implemented one. --> do the create user in the internal mode Elke SAP Labs Berlin > > Thanx and Greets, > Mathias > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
