Activity overview
Latest activity by DOKMANC2
License Question
I am currently on version 5.7.31.2684 of Schema Compare for Oracle. The app is notifying me that there is a major version update available Version 6.0.19. if I upgrade, will my licensed version rev...
I still don't understand why the product works when one schema is selected. The product must execute different unnecessary code when multiple schemas are selected and that the solution to make your product more accessible to security conscious customers to is to avoid the 2nd path and two do the 1st path once per schema. Internal Security just told me to use TOAD compare and contacted Software purchasing to take Red Gate software off the list of approved software. Goodbye. / comments
I still don't understand why the product works when one schema is selected. The product must execute different unnecessary code when multiple schemas are selected and that the solution to make your...
It looks like our company tightened up access when they upgraded out dbs to 19c. From past experience, I don't expect anyone is going to grant me special access to use Red Gate tools. i clearly don't have access to sys.tab$ , sys.obj$ and the Red Gate docs say that this is needed. See the email from my DBA. The product is only 13 mos old. Can I get a credit to buy something else? Otherwise, maybe I can put it on eBay. Interested parties, reply to this post. Hi Chad,
On looking at the logs and your
previous access.
You had “SELECT ANY TABLE”
privilege to your LAN id which might have masked all the individual access
needed to run these queries when the database was on 12c version.
As part of CIP standard,
granting “SELECT ANY TABLE” is not allowed on individual lan id’s.
19c upgrade cleaned up most of
the vulnerabilities as directed from CIP.
For the below query, you need
select access on sys.sys_fba_period , sys.tab$ , sys.obj$ and all_users
objects.
Again, these objects are
internal db objects and access to them are restricted.
I have copied our dba security
team who can assist you further on this.
Thanks, / comments
It looks like our company tightened up access when they upgraded out dbs to 19c. From past experience, I don't expect anyone is going to grant me special access to use Red Gate tools. i clearly do...
I attached the verbose log file here and saved but I don't see the log. I got no error. I also submitted it as a case. What is puzzling is that when I selected only one schema, even though the UI appears to work fine the log shows SQLs followed by error messages like "view does not exist". Furthermore, I can execute the SQLs that the log reports as having raised errors. When I select multiple schemas, I see one different error that may be important. This SQL I actually cannot execute myself as I get the same 'table or view does not exist" error reported in the log. Is access to the two $ views really required? Why are they only required when comparing multiple schemas? WITH m_owners AS ( SELECT 'FDS_APPS' as owner from dual ) SELECT u.username as OWNER, o.NAME as TABLE_NAME, p.periodname as PERIOD_NAME, p.flags as FLAGS, p.periodstart as PERIOD_START, p.periodend as PERIOD_END FROM sys.sys_fba_period p,sys.tab$ t,sys.obj$ o, all_users u, m_owners WHERE p.obj# = t.obj# AND t.obj# = o.obj# AND o.owner# = u.user_id AND u.username = m_owners.owner; / comments
I attached the verbose log file here and saved but I don't see the log. I got no error. I also submitted it as a case.What is puzzling is that when I selected only one schema, even though the UI ap...
I attached the verbose log / comments
I attached the verbose log
I upgraded to 5..15.1555 and got the same error, which I submitted the same way, through the application capturing and sending an email. By the wat, before I upgraded, I selected the "Check for Updates" menu option and got a message that I was on the latest version. Due to past experience with upgrades resulting in my app turning into a demo version I figured this was the most likely way to upgrade to a version that would still be considered registered. / comments
I upgraded to 5..15.1555 and got the same error, which I submitted the same way, through the application capturing and sending an email.By the wat, before I upgraded, I selected the "Check for Upda...
if I have any further questions, I'll be sure to contact "Red Gate Support" / comments
if I have any further questions, I'll be sure to contact "Red Gate Support"
Since I can compare two 19c database as long as I only select one schema at a time but it fails when I select multiple schema, do you accept that this is a product bug instead of a permissions issue? / comments
Since I can compare two 19c database as long as I only select one schema at a time but it fails when I select multiple schema, do you accept that this is a product bug instead of a permissions issue?
What do you think? / comments
What do you think?
What do you think? / comments
What do you think?