|
|
| Re: Why do we require password while creating a ROLE? [message #71600 is a reply to message #71599] |
Wed, 27 November 2002 07:14  |
 |
Mahesh Rajendran
Messages: 10708
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
