Grants not showing in Deployment
DiogoTM
Posts: 2 New member
Hello Everyone,
I'm having a few grants not showing in the script for deployment.
After comparing the databases the differences are identified but when I run the deployment wizard the code is not there.
Example: Comparing e_example_old to e_example_new
Is there any settings I might be missing or any known reason for this to happen?
Thanks.
I'm having a few grants not showing in the script for deployment.
After comparing the databases the differences are identified but when I run the deployment wizard the code is not there.
Example: Comparing e_example_old to e_example_new
-- Target privileges
GRANT DELETE ON e_example_old.e_stuff TO e_example_new WITH GRANT OPTION;
GRANT INSERT ON e_example_old.e_stuff TO e_example_new WITH GRANT OPTION;
GRANT SELECT ON e_example_old.e_stuff TO e_example_new WITH GRANT OPTION;
GRANT UPDATE ON e_example_old.e_stuff TO e_example_new WITH GRANT OPTION;
After running Deployment this is the script generated:
After running Deployment this is the script generated:
--
-- Script generated by Schema Compare for Oracle 5.6.0.2170 on 15/11/2019 17:28:03
--
SET DEFINE OFF
Is there any settings I might be missing or any known reason for this to happen?
Thanks.
Tagged:
Best Answer
-
Eddie D
Posts: 1,802 Rose Gold 5
Hi, thank you for your reply.I have submitted new Bug Report OC-1174 to bring this issue to the attention of the development team. The experienced behavior is not expected.
Sadly, I am unable to provide an ETA as to when a bug fix version will become available. I will update when a Bug Fix version of Schema Compare for Oracle becomes available.
Many Thanks
Eddie
Answers
The behaviour you have described does appear to be a little odd. However, I believe I have experienced this error myself or something similar.
In my example, the comparison results show all the required GRANTS. Upon running the deployment process, some of the GRANTS were not included in the deployment.
I successfully deployed the changes and on the subsequent refresh of the comparison, the missing GRANTS are still seen in the results. Run the deployment wizard again and on this occasion the missing GRANTS from the first deployment and now listed or included in the deployment.
Are you experiencing this problem described above?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
Yes I'm having that exact behavior. After running the deployment I still see the missing grants. But a second run of the deployment 'fixed' the issue.
Do you have any idea what may be causing it, or if there is any way around it?
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com