Home » RDBMS Server » Security » DEFAULT ROLE
DEFAULT ROLE [message #6940] Tue, 13 May 2003 01:00
Igor
Messages: 8
Registered: March 2000
Junior Member
Hi!
User IGOR create role I_ADMIN. Users TEST1 and TEST2 already are created.
Then user IGOR execute: GRANT I_ADMIN TO TEST1;
GRANT I_ADMIN TO TEST2;
but when
select * from dba_role_privs where grantee in ('TEST1', 'TEST2')
column DEFAULT ROLE = YES for user TEST1 and DEFAULT ROLE = NO for user TEST2
Where these users differ?
Script for users:

CREATE USER "TEST1" IDENTIFIED BY VALUES '09D528EDB6A59F14'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT;

CREATE USER "TEST2" IDENTIFIED BY VALUES '4D6F53A248459F6E'
DEFAULT TABLESPACE SYSTEM
TEMPORARY TABLESPACE SYSTEM
PROFILE DEFAULT;

User TEST2 was created about 5 months later, when and how I don't know.

Many Thanks.
Igor Melnik
Previous Topic: Grant/ Revoke permission
Next Topic: User Name and Password
Goto Forum:
  


Current Time: Thu Sep 23 07:16:26 CDT 2021