Does JDBC support 'ALTER USER userid IDENTIFIED BY password' command
843859May 7 2007 — edited May 7 2007Does JDBC support ALTER USER userid IDENTIFIED BY password command.
More precisely does PreparedStatement / Statement object supports DCL (GRANT/REVOKE/ALTER USER)commands.
I am using JDBC thin Type4 driver to connect to Oracle 8.1.7 from appliaction.
I am getting java.sql.SQLException: ORA-01935: missing user or role name in execute Update() method.
Does PreaparedStatement inadvertently puts quote to the passing variable since when I run the command in sqlplus in unix with the same userid it works fine.see below (I used it in 2 ways)
SQL> ALTER USER 'webload' IDENTIFIED BY 'Citibank3';
ALTER USER 'webload' IDENTIFIED BY 'Citibank3'
*
ERROR at line 1:
ORA-01935: missing user or role name
SQL> ALTER USER webload IDENTIFIED BY Citibank3;
User altered.