Home » Other » General » DEFAULT ROLE
DEFAULT ROLE [message #103305] Tue, 13 May 2003 01:02
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: Oracle Sandbox
Next Topic: Oracle API
Goto Forum:
  


Current Time: Thu Mar 28 10:58:39 CDT 2024