| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
