Re: Role Password

Dave Writz (davew_at_crnrstne.com) wrote:
: Does anyone know where the password for a role is stored in the system
: catalogs? I know the the user passwords are stored encrypted in
: DBA_USERS, but where is the role password stored?
:
: Thanks in advance

DBA_USERS is a view of several tables, including USER$. Role passwords are stored in the USER$ table as well as user passwords. THe DBA_USERS view strips the roles out.

Joe

-- 
                                   
=------------------------------------------------------------------=
Joe Nardone <joe_at_access.digex.net>                  
  "Me fail English?  That's unpossible!" - Ralph Wiggum

-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: 2.6.2

mQBtAzCg5QoAAAEDANvEmc4OAT8wntnCv8UPjyD2kohKVGa1CU21PLpYljzl3AE7
pldpNNscKSoE//aVMKYBO+tRFTTsPNi0qZ6CDlEBXTgJAiszoHh1qCzZyYj7FTBL
YoUr+3sk9rU8Pma6AQAFEbQiSm9lIE5hcmRvbmUgPGpvZUBhY2Nlc3MuZGlnZXgu
bmV0Pg==
=1ocE
-----END PGP PUBLIC KEY BLOCK-----