Home » SQL & PL/SQL » SQL & PL/SQL » how to list all existing users of database
how to list all existing users of database [message #255874] Thu, 02 August 2007 04:17 Go to next message
rajesh_bhadu
Messages: 48
Registered: June 2007
Member
Hi All,

I am using oracle 10g.
I have created some user/schema in my XE database.
Some of them i have dropped.

Now I want to check how many users exist in database.

I have executed following querry to see all the users schema.
select * from all_users;


But above querry results all the user even though they have been deleted.

So please tell me how can I list all the non deleted users.


Thanks in advance.

Rajesh Embarassed
Embarassed
Re: how to list all existing users of database [message #255879 is a reply to message #255874] Thu, 02 August 2007 04:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If they have been dropped they are no more in the view.

Regards
Michel
Re: how to list all existing users of database [message #255881 is a reply to message #255879] Thu, 02 August 2007 04:52 Go to previous messageGo to next message
rajesh_bhadu
Messages: 48
Registered: June 2007
Member
Sorry I m not getting you clearly.....

At database home page they are not exist under administrator> manage user link.

But I want to check through SQL query.
Re: how to list all existing users of database [message #255883 is a reply to message #255874] Thu, 02 August 2007 04:55 Go to previous messageGo to next message
lamusah
Messages: 5
Registered: March 2005
Location: Ghana
Junior Member

Use the flash back command
Re: how to list all existing users of database [message #255884 is a reply to message #255883] Thu, 02 August 2007 04:58 Go to previous messageGo to next message
rajesh_bhadu
Messages: 48
Registered: June 2007
Member
Please tell me how to purge system level recyclebin.
Re: how to list all existing users of database [message #255890 is a reply to message #255881] Thu, 02 August 2007 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I understand your question and I say: "select * from all_users" gives you the users currently existing and not deleted ones.
When they are dropped they no more exists anywhere in the database.


Regards
Michel
Re: how to list all existing users of database [message #255891 is a reply to message #255884] Thu, 02 August 2007 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Please tell me how to purge system level recyclebin

This is another question, create another topic.

Regards
Michel
Re: how to list all existing users of database [message #255892 is a reply to message #255884] Thu, 02 August 2007 05:09 Go to previous message
rajesh_bhadu
Messages: 48
Registered: June 2007
Member
Thanx all for your help.
@Michel you are right.. I m wrong ..they are not in view...just a refreshing is required.

Sorry for not doing refreshing before posting.
Previous Topic: Display records not having particular code
Next Topic: continue after exception
Goto Forum:
  


Current Time: Sat Dec 03 18:26:10 CST 2016

Total time taken to generate the page: 0.28840 seconds