Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Recreating roles with passwords

Re: Recreating roles with passwords

From: amit poddar <amit.poddar_at_yale.edu>
Date: Wed, 15 Aug 2007 13:12:30 -0400
Message-ID: <46C333FE.1040803@yale.edu>


Look at the definition of dba_roles view

select name, decode(password, null, 'NO', 'EXTERNAL', 'EXTERNAL','GLOBAL', 'GLOBAL', 'YES')
from user$
where type# = 0 and name not in ('PUBLIC', '_NEXT_USER')

It seems that the roles are stored in user$ table along with the users with type#=0
type#=1 is for the users.
But the role password is not exposed via any view. So maybe you can go against user$ table itself or create your own view exposing the role passwords also

amit

Don Seiler wrote:
> I'm writing a little perl script to migrate users and roles to another
> server. Some of the roles have passwords, but I can't find the
> passwords. The dba_users view, for example, gives me the encrypted
> value of the user's password so that I can build my CREATE USER sql
> statement with IDENTIFIED BY VALUES. Does anyone know where, if
> anywhere, I can find the password for a role so that I can recreate
> it?
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 15 2007 - 12:12:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US