Hello,
Is it possible to create user in Oracle with VBA from cell value?
I have defined connections etc., loop to check cells for values and for each cell with some value i need to run create user command in oracle
Below lines are not working
Dim SqlString As String
SqlString = "create user '" & user & "' identified by '" & user & "' default tablespace XXXX temporary tablespace XXXX"
Set MyRecordSet = New ADODB.Recordset
MyRecordSet.Open SqlString, cnn, adOpenDynamic, adLockOptimistic
Still dropping ORA-01935: missing user or role name even as the SqlString has the values for user / password.
Is it possible to create user in Oracle with VBA from cell value?
I have defined connections etc., loop to check cells for values and for each cell with some value i need to run create user command in oracle
Below lines are not working
Dim SqlString As String
SqlString = "create user '" & user & "' identified by '" & user & "' default tablespace XXXX temporary tablespace XXXX"
Set MyRecordSet = New ADODB.Recordset
MyRecordSet.Open SqlString, cnn, adOpenDynamic, adLockOptimistic
Still dropping ORA-01935: missing user or role name even as the SqlString has the values for user / password.
