user_users and dba_users [message #2628] |
Thu, 01 August 2002 01:06 |
Mark Grimshaw
Messages: 73 Registered: June 2002
|
Member |
|
|
I am a bit confused as to what user_users and dba_users actually hold. For example if I am logged in on SQL Plus as SYSTEM and create a user say 'fred' this name will appear in the list of dba_users but not in the user_users - is fred really a dba ?
Thanks
Mark
|
|
|
Re: user_users and dba_users [message #2629 is a reply to message #2628] |
Thu, 01 August 2002 04:23 |
hanu
Messages: 21 Registered: March 2002
|
Junior Member |
|
|
I don't think that the new user you have created is having dba roles. If you create any user that is visible from dba_users view. The user_users view have the connected user details only. I mean to say if you connected with New user, you can see the new user details in user_users view.
Rgds,
Hanu.
|
|
|