Hello,
me and about 40 my co-workers migrated TOAD from version 9 to version 12 two months ago.
We found some unhappy behaviour of new verison (TOAD for Oracle 32-bit, v12.1.0.22).
If there is some option in toad options which can be used to to help us i will be thankful to you 
Thank you.
KR, Robert Mackovik
And of course if there is no help in this version, we would like to add this to next version of TOAD Thanks.
Hi Robert,
I just tried this using a standard Toad license with no bells and whistles. I typed in DELETE_CATALOG_ROLE in the editor and F4’d on it. The describe
window came up without a problem. Are you getting some error message?
Yes, this was a requested change in behavior. I don’t mind changing it back (or making it optional if they are stored by object type or globally),
but I think this is something that should go through idea pond. If it gets a lot of support there, I’ll change it.
http://toadfororacle.ideascale.com/
-John
From: Robert Mackovik [mailto:bounce-rmackovik@toadworld.com]
Sent: Saturday, October 19, 2013 5:47 AM
Subject: [Toad for Oracle - Discussion Forum] Change toad v.9 to v.12 - some difference in behaviour
Change toad v.9 to v.12 - some difference in behaviour
Thread created by Robert Mackovik
Hello,
me and about 40 my co-workers migrated TOAD from version 9 to version 12 two months ago.
We found some unhappy behaviour of new verison (TOAD for Oracle 32-bit, v12.1.0.22).
If there is some option in toad options which can be used to to help us i will be thankful to you
Can’t use F4 for describe of role in editor
Object filters in schema browser are different for each tab
Thank you.
KR, Robert Mackovik
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Hi John,
thank you for your reply.
But in schema browser at Roles tab i see this role. I have access to DBA_ROLES view, also to DBA_TAB_PRIVS view.
Robert
I think that I haven’t rights for a different sys view wich has nothing to do with roles. Is the way in which TOAD seeks objects correct? Eg if i have not rights to see DBA_USERS, is correct to say that “Object DELETE_CATALOG_ROLE not found”? If this is the cause than i think this is a bug.
I tried to log in as different user with greater rights, and popup window with role has shown, as you said, thank you.
I used SQL tracker to identify the select when i press F4 in editor, and I saw few selects with union. Eg. select with roles:
Select ‘USER’ object_type, null owner, username object_name
from sys.DBA_USERS
where username = ‘DELETE_CATALOG_ROLE’
union all
Select ‘TABLESPACE’ object_type, null owner, tablespace_name object_name
from sys.DBA_TABLESPACES
where tablespace_name = ‘DELETE_CATALOG_ROLE’
union all
Select ‘PROFILE’ object_type, null owner, profile object_name
from sys.dba_profiles
where profile = ‘DELETE_CATALOG_ROLE’
and rownum = 1
union all
Select ‘ROLE’ object_type, null owner, role object_name
from sys.dba_roles
where role = ‘DELETE_CATALOG_ROLE’
If I have not rights for DBA_USERS and DBA_PROFILES, then I can’t see ROLES in popup window.
Is my suspicion right?
Thank you.
Robert
Ah-hah! Yes, that is the problem. Good detective work.
It shouldn’t be querying against dba_profiles if you don’t have privileges on it, but I see a mistake in the check for privileges there. I will fix that.
The check for dba_users looks good. I think the problem is dba_profiles.
-John
From: Robert Mackovik [mailto:bounce-rmackovik@toadworld.com]
Sent: Tuesday, October 22, 2013 12:54 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Change toad v.9 to v.12 - some difference in behaviour
RE: Change toad v.9 to v.12 - some difference in behaviour
Reply by Robert Mackovik
I think that I haven’t rights for a different sys view wich has nothing to do with roles. Is the way in which TOAD seeks objects correct? Eg if i have not rights to see DBA_USERS, is correct
to say that “Object DELETE_CATALOG_ROLE not found”? If this is the cause than i think this is a bug.
I tried to log in as different user with greater rights, and popup window with role has shown, as you said, thank you.
I used SQL tracker to identify the select when i touch F4 in editor, and I saw few selects with union. Eg. select with roles:
Select ‘USER’ object_type, null owner, username object_name
from sys.DBA_USERS
where username = ‘DELETE_CATALOG_ROLE’
union all
Select ‘TABLESPACE’ object_type, null owner, tablespace_name object_name
from sys.DBA_TABLESPACES
where tablespace_name = ‘DELETE_CATALOG_ROLE’
union all
Select ‘PROFILE’ object_type, null owner, profile object_name
from sys.dba_profiles
where profile = ‘DELETE_CATALOG_ROLE’
and rownum = 1
union all
Select ‘ROLE’ object_type, null owner, role object_name
from sys.dba_roles
where role = ‘DELETE_CATALOG_ROLE’
If I have not rights for DBA_USERS and DBA_PROFILES, then I can’t see ROLES in popup window.
Is my suspicion right?
Thank you.
Robert
To reply, please reply-all to this email.
Stop receiving emails
on this subject.
Or Unsubscribe from Toad for Oracle - General
notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
Thank you John,
when fixed version will be deployed, can I expect a message here or I have to check “whats new” files for each future version?
I am fairly pleased with this (your) support quality (it’s contrasting to Oracle support).
I’ve already fixed it. The fix will be in the next announced 12.5 beta, and in 12.5 GA. There probably won’t be any announcement of this bug since it just
came up through the forum. The forum isn’t an official support channel, but it is generally the fastest way to get to the developers. If you want the bug to get a case number and be tracked, you have to go through Dell support.
-John
From: Robert Mackovik [mailto:bounce-rmackovik@toadworld.com]
Sent: Wednesday, October 23, 2013 6:24 AM
Subject: RE: [Toad for Oracle - Discussion Forum] Change toad v.9 to v.12 - some difference in behaviour
RE: Change toad v.9 to v.12 - some difference in behaviour
Reply by Robert Mackovik
Thank you John,
when fixed version will be deployed, can I expect a message here or I have to check “whats new” files for each future version?
I am fairly pleased with this (your) support quality (it’s contrasting to Oracle support).
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.
