Re: 11g Patchset 1 Changes
- From: fairlie rego <fairlie_r@xxxxxxxxx>
- To: sblackbu@xxxxxxxxx
- Date: Fri, 24 Apr 2009 21:34:44 -0700 (PDT)
It is my understanding that password protected roles are no longer enabled even
if they are default roles.
I am hoping this will be documented in 11.2 but bug 7581798
ROLES WITH PASSWORD DON'T WORK WHEN LOGON
was closed due to the above
Thanks
Fairlie Rego
Senior Oracle Consultant
http://el-caro.blogspot.com/
M: +61 402 792 405
--- On Fri, 24/4/09, Stuart Blackburn <sblackbu@xxxxxxxxx> wrote:
From: Stuart Blackburn <sblackbu@xxxxxxxxx>
Subject: 11g Patchset 1 Changes
To: oracle-l@xxxxxxxxxxxxx
Received: Friday, 24 April, 2009, 10:50 PM
Just wondering if anyone knows if they've changed the way roles work in patch
set 1 or this behavior is unexpected. I can't seem to find any relevant
documentation on it online to see if this is expected.
11.1.0.6:
SQL> create role testrole identified by testrole;
Role created.
SQL> create user testuser identified by testuser;
User created.
SQL> grant create session to testrole;
Grant succeeded.
SQL> grant testrole to testuser;
Grant succeeded.
SQL> connect testuser/testuser;
Connected.
SQL>
11.1.0.7:
SQL> create role testrole identified by testrole;
Role created.
SQL> create user testuser identified by testuser;
User created.
SQL> grant create session to testrole;
Grant succeeded.
SQL> grant testrole to testuser;
Grant succeeded.
SQL> connect testuser/testuser;
ERROR:
ORA-01045: user TESTUSER lacks CREATE SESSION privilege; logon denied
If I create the role without a password it works though.
Thanks
Stuart
--
//www.freelists.org/webpage/oracle-l
The new Internet Explorer 8 optimised for Yahoo!7: Faster, Safer, Easier.
Other related posts:
