Red Gate forums :: View topic - Object grants not correctly compared by Source Ctrl Oracle.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
Source Control for Oracle
Source Control for Oracle forum

Object grants not correctly compared by Source Ctrl Oracle.

Search in Source Control for Oracle forum
Post new topic   Reply to topic
Jump to:  
Author Message
Ivan



Joined: 22 Apr 2014
Posts: 7

PostPosted: Tue Apr 29, 2014 12:43 pm    Post subject: Object grants not correctly compared by Source Ctrl Oracle. Reply with quote

Hi,

Although Schema Compare for oracle correctly compares object grants, Source Control For Oracle seems not.
Apparently SCFO is ignoring the grants to roles.


Regards,
Ivan
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 937
Location: Red Gate Software

PostPosted: Wed Apr 30, 2014 3:04 pm    Post subject: Reply with quote

Hi Ivan

Is there any error message when you attempt a check-in or Get Latest with regards to the grants applied to roles?

Does the product throw a dialog that allows you to submit an error report?

Does it appear to initially check-in the changes but once it has refreshed still shows the grants as waiting to be checked in?

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
Ivan



Joined: 22 Apr 2014
Posts: 7

PostPosted: Wed Apr 30, 2014 3:25 pm    Post subject: Reply with quote

Hi Eddie,

Verifying to answer your question has shown I overlooked the role grants...
So, there is no problem with the grants to roles, you can close this ticket.

Reasons I missed them are :
- in Schema compare for Oracle, both grants to users and roles are grouped together while in SC for Oracle the are separate.
- Due to the lack of sort functionality on the screen, and the fact they were very far from each other in a long list of objects (initial load into subversion), I found the grants to user, but overlooked the grants to roles.


Sorry for my misstake,
Ivan
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group