OraFAQ Forum: Security » Roles not active after update to 10.2.0.5

Home » RDBMS Server » Security » Roles not active after update to 10.2.0.5 (10.2.0.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Roles not active after update to 10.2.0.5 [message #458074]

Thu, 27 May 2010 04:14

Gogetter
Messages: 39
Registered: December 2009
Location: Cologne Germany

Member

Hi,

we just updated our testing db from 10.2.0.3.0 to 10.2.0.5.0. and now we have some problems with roles.

Most roles are identified by Password and are granted to user as default:

GRANTED_ROLE                   ADMIN_OPTION DEFAULT_ROLE 
------------------------------ ------------ ------------ 
CONNECT                        NO           YES          
ENTWICKLER                     NO           YES          
MITARBEITER_EDV                NO           YES

ROLE                           PASSWORD_REQUIRED 
------------------------------ ----------------- 
CONNECT                        NO                
ENTWICKLER                     YES               
MITARBEITER_EDV                YES

Now when connecting to database only the roles without password are active.

SELECT * FROM SESSION_ROLES
ROLE
------------------------------
CONNECT

Before upgrading to 10.2.0.5.0 alle roles were active which were granted as default.

What happens, where I'm wrong?

ty for reading and helping
Rudi

Report message to a moderator

[Message index]

		Roles not active after update to 10.2.0.5 By: Gogetter on Thu, 27 May 2010 04:14
		Re: Roles not active after update to 10.2.0.5 By: Michel Cadot on Thu, 27 May 2010 04:24
		Re: Roles not active after update to 10.2.0.5 By: Gogetter on Thu, 27 May 2010 04:41
		Re: Roles not active after update to 10.2.0.5 By: ramoradba on Thu, 27 May 2010 09:32

Previous Topic:	Security policies for products
Next Topic:	error starting the collectors audit vault

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 15:22:46 CDT 2024