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
Kevin
Messages: 45
Registered: February 2000
Member
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: 10707
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> /

ROLE PASSWORD
------------------------------ --------
ANOTHE_ROLE NO
Previous Topic: Authentication in Stored Procedure
Next Topic: DBMS_OBFUSCATION_TOOLKIT not present !
Goto Forum:
  


Current Time: Thu Mar 28 12:05:29 CDT 2024