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.
From: Robert Mackovik [mailto:firstname.lastname@example.org]
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
where username = ‘DELETE_CATALOG_ROLE’
Select ‘TABLESPACE’ object_type, null owner, tablespace_name object_name
where tablespace_name = ‘DELETE_CATALOG_ROLE’
Select ‘PROFILE’ object_type, null owner, profile object_name
where profile = ‘DELETE_CATALOG_ROLE’
and rownum = 1
Select ‘ROLE’ object_type, null owner, role object_name
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?
To reply, please reply-all to this email.
Stop receiving emails
on this subject.
Or Unsubscribe from Toad for Oracle - General
Toad for Oracle - Discussion Forum
this post as spam/abuse.