Home » RDBMS Server » Security » Why do we require password while creating a ROLE?
Why do we require password while creating a ROLE? [message #71599] Wed, 27 November 2002 06:40 Go to next message
Messages: 45
Registered: February 2000
why is it necessary to use keyword PASSWORD when creating a ROLE?
Re: Why do we require password while creating a ROLE? [message #71600 is a reply to message #71599] Wed, 27 November 2002 07:14 Go to previous message
Mahesh Rajendran
Messages: 10697
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
it is not a must!.
quoting the docs:
The IDENTIFIED BY clause specifies the form of authorization that must be provided before the role
can be enabled for use by a specific user to which it has been granted. If this clause is not specified, or
NOT IDENTIFIED is specified, then no authorization is required when the role is enabled. Roles can be
specified to be authorized by the database, externally, or globally.


SQL> ed
Wrote file afiedt.buf

1* create role anothe_role
SQL> /

Role created.

SQL> select * from dba_roles
2 where role='ANOTHER_ROLE';

no rows selected

SQL> ed
Wrote file afiedt.buf

1 select * from dba_roles
2* where role='ANOTHE_ROLE'
SQL> /

------------------------------ --------
Previous Topic: Authentication in Stored Procedure
Next Topic: DBMS_OBFUSCATION_TOOLKIT not present !
Goto Forum:

Current Time: Sun May 22 12:31:59 CDT 2022