Home » RDBMS Server » Server Utilities » users in databse
users in databse [message #249231] Tue, 03 July 2007 12:53 Go to next message
qasim845
Messages: 95
Registered: March 2007
Location: Philadelphia
Member

Is anybody can share the script with me for this. I have two database. I need to find out how many users in db1 does not exists in db2.
Oracle version
9.2.6.0

thanks in advance
Re: users in databse [message #249232 is a reply to message #249231] Tue, 03 July 2007 13:01 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Connected users?? or total no of users?


select username from dba_users;

select username from dba_users@2nd_db;
Re: users in databse [message #249233 is a reply to message #249231] Tue, 03 July 2007 13:02 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
while logged into DB1

select username from dba_users
minus
select username from dba_users@db2
/
Previous Topic: "create" and "export schema" merged
Next Topic: Tns service name
Goto Forum:
  


Current Time: Thu Dec 08 10:29:18 CST 2016

Total time taken to generate the page: 0.10293 seconds