Mario Huetten wrote: > > Hello Alexander, > > thanks for the response and your hint. Now it works with a user named > "TEST". But if i try to use a username with a dot in the name (like > "MARIO.HUETTEN"), it does not work. The following error > occured: General > error;-4003 POS(17) Unknown user name. I also tried this in > SQL Studio, > the same error. > > Greetings from Berlin Karow, > Mario
Thank you for reporting. ALTER PASSWORD <user> <password> will always end with -4003 if <user> is specified as special identifier (with "..."). Please try to use the other syntax option with <old password> TO <new password> Elke SAP Labs Berlin > > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 18. September 2003 14:40 > An: 'Mario Huetten' > Cc: '[EMAIL PROTECTED]' > Betreff: RE: Alter password using JDBC > > > Hello Mario, > > have you tried to execute it as 'normal' Statement (not a > PreparedStatement)? Some commands may not be able to be executed as > prepared SQL statement. > > Alexander Schr�der > SAP DB, SAP Labs Berlin > > > -----Original Message----- > > From: Mario Huetten [mailto:[EMAIL PROTECTED] > > Sent: Thursday, September 18, 2003 2:04 PM > > To: [EMAIL PROTECTED] > > Subject: Alter password using JDBC > > > > > > Hello, > > > > we have a problem changing a password by using JDBC. The > Connection to > > > the Database was established with the USER "DBA". Trying to > change the > > > password of the user "TEST" with the preparedStatement > "ALTER PASSWORD > > > TEST abc" results in error code -5001: Missing privilege. > Connecting > > to Database with SQL-Studio with the user "DBA" and changing the > > password works fine. > > > > Any hints ? > > > > Thanks, Mario > > > > > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > > > > > -- > 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]
