2 Replies Latest reply: May 28, 2010 1:42 AM by 774686 RSS

    Special character when changing password in sql plus

    774686
      Hi i'm having a problem with setting password for user's in sql plus. I get a ORA-00922 whenever I try to change a user's password to contain ! in it. See below. Do I have to escape special characters or something or this a bug?

      (Previously I've always used Enterprise Manager for this and can set ! characters for password without issue but we're currently having an issue with it and I need to alter passwords in sql plus while I'm waiting for it to be fixed )


      SQL> alter user lbtest identified by oraclesux!;
      alter user lbtest identified by oraclesux!
      *
      ERROR at line 1:
      ORA-00922: missing or invalid option


      SQL> alter user lbtest identified by oraclesux;

      User altered.

      System and O/S details below:

      O/S = MS Server 2008 Standard Service Pack 1 64 bit
      Oracle 11g Standard Edition (11.1.0.7.0)

      SQL> select * from nls_database_parameters;

      PARAMETER VALUE
      ----------------------------------------
      NLS_LANGUAGE AMERICAN
      NLS_TERRITORY AMERICA
      NLS_CURRENCY $
      NLS_ISO_CURRENCY AMERICA
      NLS_NUMERIC_CHARACTERS .,
      NLS_CHARACTERSET WE8MSWIN1252
      NLS_CALENDAR GREGORIAN
      NLS_DATE_FORMAT DD-MON-RR
      NLS_DATE_LANGUAGE AMERICAN
      NLS_SORT BINARY
      NLS_TIME_FORMAT HH.MI.SSXFF AM

      PARAMETER VALUE
      ----------------------------------------
      NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
      NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
      NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
      NLS_DUAL_CURRENCY $
      NLS_COMP BINARY
      NLS_LENGTH_SEMANTICS BYTE
      NLS_NCHAR_CONV_EXCP FALSE
      NLS_NCHAR_CHARACTERSET AL16UTF16
      NLS_RDBMS_VERSION 11.1.0.7.0

      20 rows selected.