Set password for the DBA role

Hello,

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

I am trying to set a password for an existing role "DBA" and it looks like I am something some where

MYDB>select role,PASSWORD_REQUIRED,AUTHENTICATION_TYPE from dba_roles where role='DBA';

ROLE                   PASSWORD AUTHENTICAT

------------------------------ -------- -----------

DBA                   NO    NONE

MYDB>alter role dba identified by test1234;

Role altered.

SHAIKDB>select role,PASSWORD_REQUIRED,AUTHENTICATION_TYPE from dba_roles where role='DBA';

ROLE                   PASSWORD AUTHENTICAT

------------------------------ -------- -----------

DBA                   YES    PASSWORD

MYDB>alter user test identified by test1234;

User altered.

MYDB>alter user test1 identified by test1;