How to define password in Oracle?

[Yingie Pitts]

How do I store users' passwords in Oracle? Should I just save it as a column with other columns (username, userId...) or save it seperately? I know Oracle encrypts passwords but how can I enable Oracle to do it for me?

[sachin kumar Kansal]

hi !
u do not explicitly store passwords in Oracle using table.
they are encrypted by oracle and that's what security is all about.
how ever u can see the details of user account from
dba_uers table.
SQL> desc dba_users
Name Null? Type
------------------------------- -------- ----
USERNAME NOT NULL VARCHAR2(30)
USER_ID NOT NULL NUMBER
PASSWORD VARCHAR2(30)
ACCOUNT_STATUS NOT NULL VARCHAR2(32)
LOCK_DATE DATE
EXPIRY_DATE DATE
DEFAULT_TABLESPACE NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE NOT NULL VARCHAR2(30)
CREATED NOT NULL DATE
PROFILE NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30)
EXTERNAL_NAME VARCHAR2(4000)