According to the Oracle9i documentation, passwords follow the same rules applied to naming schema objects. This includes "alphanumeric characters from your database character set and the underscore (_), dollar sign ($), and pound sign (#)." What discrepancies are you encountering? On Mon, 11 Oct 2004 23:32:42 -0700 (PDT), Ravi B <ravi4ora@xxxxxxxxx> wrote: > What are the special characters that can be used in the oracle database > user's password.? > > What special characters cannot be used. > > Also i see some discrepencies when using some special characters that work > when creating the user but will not work when used in the new password with > the alter user statement. > <snip> -- //www.freelists.org/webpage/oracle-l