DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2000

    Cannot have ! in oracle password?

    I am not able to put the exclamation point in a password:

    demo40@ORCLDEV> create user testtest identified by testtest;

    User created.

    demo40@ORCLDEV> alter user testtest identified by test!test;
    alter user testtest identified by test!test
    ERROR at line 1:
    ORA-00922: missing or invalid option

    demo40@ORCLDEV> select * from v$version;

    Oracle Database 10g Enterprise Edition Release - Prod
    PL/SQL Release - Production
    CORE Production
    TNS for 32-bit Windows: Version - Production
    NLSRTL Version - Production


    Any idea why?

  2. #2
    Join Date
    Apr 2006
    SQL> grant connect to test1_user identified by test!pass;
    grant connect to test1_user identified by test!pass
    ERROR at line 1:
    ORA-00933: SQL command not properly ended
    SQL> grant connect to test1_user identified by "test!pass";
    Grant succeeded.
    SQL> conn test1_user/test!pass
    Nonquoted identifiers can contain only alphanumeric characters from your database character set and the underscore (_), dollar sign ($), and pound sign (#). Refer to Schema Object Naming Rules.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.