Home » SQL & PL/SQL » SQL & PL/SQL » Compare Database users
Compare Database users [message #245580] Mon, 18 June 2007 03:05 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii all

i have two users
those users are not similar in some tables and procedures

is there any function or builtin function that i can use it to compare those two users

Thanks for everyone helped and helping me
Re: Compare Database users [message #245590 is a reply to message #245580] Mon, 18 June 2007 03:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Many tools can do it for you: OEM, TOAD...

For myself I use dbms_metadata + diff.

Regards
Michel
Re: Compare Database users [message #245592 is a reply to message #245580] Mon, 18 June 2007 03:27 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Is there any builtin function in sql can use it for this comparison
Re: Compare Database users [message #245594 is a reply to message #245592] Mon, 18 June 2007 03:30 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, of course but I don't want to share it with you so I didn't tell...

Just a joke of course.

There is none I'm aware of.

Regards
Michel
Previous Topic: RANGE type clause in analytic function
Next Topic: What is wrong with this procedure
Goto Forum:
  


Current Time: Fri Dec 09 07:47:49 CST 2016

Total time taken to generate the page: 0.09598 seconds