PL*SQL - Which users are ACTIVE ? [message #494688] |
Wed, 16 February 2011 10:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/3f1cb928266af3dd808cb591565ee220?s=64&d=mm&r=g) |
Quetzalcoatl1
Messages: 33 Registered: January 2011
|
Member |
|
|
Hi to all,
I type the following command to know what users have access to the database i'm currently connected to:
SQL> select *
2 from all_users
3 /
I know need to know what users are active or inactive.
Is there a PL*SQL command for that ?
Thanks !
|
|
|
|
|
|
|
|
|
|
|
|
Re: PL*SQL - Which users are ACTIVE ? [message #494752 is a reply to message #494715] |
Wed, 16 February 2011 23:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68684 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: I'm not the DBA, which means i wont even be able to see that information ? Ok then.
So how are you able to query dba_users, dba_sys_privs and execute alter user?
Anyway, I meant that if you are not the DBA you have not access to this information.
Regards
Michel
[Updated on: Wed, 16 February 2011 23:23] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|