Duplicate grants

Rahim Kanjiyani · February 18, 2020 8:47PM

Hello,

I have upgraded my Source Control for Oracle from 3.x to the latest version (5.x). How do I generate grants for oracle roles in the latest version?

for example, grant select on <table> to <oracle_role>;

Thanks,
Rahim

Rahim Kanjiyani · February 18, 2020 10:39PM

Never mind, it looks like that grants are generated completely differently in 5.x.

I can see grants to oracle roles under object files. Previously, role grants were under role specific file name.

Rahim Kanjiyani · February 19, 2020 5:00PM

It looks like that grants are duplicated in schemas.

For example, I have grants from schema A to Schema B. When I generate source for Schemas A and B together, the grants are duplicated under UserObjectPrivileges in Schema A and B both.

Is this the desired behaviour?

Eddie D · February 20, 2020 2:53PM

Hi, thank you for your forum post.

Grants were split into Object Grants and System Grants in V3.1.8 back in May 2017, along with various bug fixes in the versions released between V3.1.8 ->V4.* ->V5.* ->V5.7.0.

Are you still using the existing project created in V3.*? If my memory is correct (thinking back to May 2017) there was some weirdness where the UserObjectPrivileges still needed to be deployed but the subsequent refresh the problem resolved itself. Thereafter the UserObjectPrivileges were no longer seen as they become Object grants.

Alternatively create a new project.

Hope the above helps.
Many Thanks
Eddie

Rahim Kanjiyani · February 20, 2020 4:40PM

Hi Eddie,

Yes, I have created new project and I can see that grants feature is completely redesigned in the latest version.

My question now is on duplicate grants.

For example, I have grants from Schema A to B. When I generate schema source code for both schemas together, the grants are duplicated in both Schema A and B. Is this an expected behavior?

Thanks,
Rahim

Eddie D · February 21, 2020 5:16PM

Hi Rahim,
Thank you for your reply.

Are you able to provide an example and (if possible) screenshots of what you experience with the duplicate Grants?

Many thanks
Eddie

Rahim Kanjiyani · February 24, 2020 11:29PM

Hi Eddy,

I have schemas called BANINST1 and BANSECR.

I have following grant on BANINST1 object to BANSECR.

For example, GRANT EXECUTE ON baninst1.gb_common TO bansecr;

This grant is duplicated in BANSECR and BANINST1 both. See screenshots below.

Image: https://us.v-cdn.net/6029854/uploads/editor/3v/r1w94j5q2cfg.png

Image: https://us.v-cdn.net/6029854/uploads/editor/m2/a4d80wgcbc9z.png

Eddie D · October 23, 2020 1:52PM

Hi,

In the recent Source Control for Oracle releases, the development team have made improvements to this area of the product. If you have not already done so, can you please upgrade to V5.7.10.444 and confirm if you still experience the problem?

To upgrade either use the Check for Updates option in the help menu of the GUI or use this link to download.

Many Thanks
Eddie

Duplicate grants

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk