Print Thread
Page 3 of 5 1 2 3 4 5
Re: Compare objects with only select_catalog_role on target user
Arunosaur #37151 02/01/10 04:51 PM
Joined: Aug 2003
Posts: 63
V
Member
Offline
Member
V
Joined: Aug 2003
Posts: 63
Any update?

Re: Compare objects with only select_catalog_role on target user
Arunosaur #37153 02/01/10 07:00 PM
Joined: Sep 2003
Posts: 387
London, UK
Member
Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
While we're at it, I notice that the 'Use DBA views if available' option doesn't work well with Compare User Objects for production vs dev/test environments at my current site, because even though my local account can access the DBA views, my read-only production account can't. I normally have the option checked, but when I want to compare something with production I have to go to preferences and uncheck it first to avoid a 'ORA-00942: table or view does not exist' error from the Target Schema dropdown when it tries to query dba_users. (Or, I've just discovered, select the target user from the list locally before connecting to the target session.) Maybe there could be a preference panel for Compare User Objects with this sort of thing on it.

Re: Compare objects with only select_catalog_role on target user
William Robertson #37235 02/08/10 05:03 PM
Joined: Aug 2003
Posts: 63
V
Member
Offline
Member
V
Joined: Aug 2003
Posts: 63
Any update?

Re: Compare objects with only select_catalog_role on target user
vllr #37315 02/16/10 03:58 PM
Joined: Aug 2003
Posts: 63
V
Member
Offline
Member
V
Joined: Aug 2003
Posts: 63
Any update?

Re: Compare objects with only select_catalog_role on target user
vllr #37373 02/22/10 03:10 PM
Joined: Aug 2003
Posts: 63
V
Member
Offline
Member
V
Joined: Aug 2003
Posts: 63
Any update?

Re: Compare objects with only select_catalog_role on target user
vllr #37379 02/23/10 11:23 AM
Joined: Aug 1999
Posts: 22,206
Member
Offline
Member
Joined: Aug 1999
Posts: 22,206
I will post here when there is an update.


Marco Kalter
Allround Automations
Re: Compare objects with only select_catalog_role on target user
Marco Kalter #37383 02/23/10 02:44 PM
Joined: Aug 2003
Posts: 63
V
Member
Offline
Member
V
Joined: Aug 2003
Posts: 63
I have been asking for this for the last 5 years.
Guys who started this thread and were asking about this fix in the others - may be if you add your opinion here it will reduce waitng time from the next 5 years to something more reasonable.

Re: Compare objects with only select_catalog_role on target user
vllr #37466 03/03/10 04:40 PM
Joined: Aug 2003
Posts: 63
V
Member
Offline
Member
V
Joined: Aug 2003
Posts: 63
I was asked today by our IT Asset Management team if we are planning to prolong our existing service contract. Based on your responses (actually - lack of responses to pretty much all of the requests that came from our company. 5 years to implement "compare user objects" in production schema looks too long, sorry) I'm not sure we need to do this. Pretty much all new bells and wistles that were implemented in 8.0 version are either useless (at least for our company, and we are very heavy on daily Oracle development) or are not working as expected.
Version 8.0.2.1505
01.60233 - Unlimited user license
Service contract 11/1/2010

Re: Compare objects with only select_catalog_role on target user
vllr #37738 04/01/10 06:32 PM
Joined: Nov 2009
Posts: 20
New Jersey, USA
J
Member
OP Offline
Member
J
Joined: Nov 2009
Posts: 20
New Jersey, USA
Hi Marco,

Do you think that this issue will be resolved a near future release. The ability to compare objects from a user that owns no objects and only has access to dba view to a target user that also owns no objects and only has access to dba view would be a great help to any developer that works in a "best practice" environment.

Other then this enhancement, we have been very happy with with 8.0.2

Thanks,

--jeff

Re: Compare objects with only select_catalog_role on target user
Jeff_1947 #37776 04/09/10 01:48 PM
Joined: Nov 2009
Posts: 20
New Jersey, USA
J
Member
OP Offline
Member
J
Joined: Nov 2009
Posts: 20
New Jersey, USA
Hi Marco,

I see the above was not fixed in 8.0.3. Any chance in next update.

Regards,

--jeff

Page 3 of 5 1 2 3 4 5

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.131s Queries: 14 (0.055s) Memory: 2.5602 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-04-29 12:23:00 UTC
Valid HTML 5 and Valid CSS