Thanks. It’s a bug. It will be fixed in the next beta. The column level grants are making it into the file from Toad, they just aren’t making it into
Toad from the file.
From: chazamania [mailto:firstname.lastname@example.org]
Sent: Thursday, February 13, 2014 1:45 PM
Subject: [Toad for Oracle - Discussion Forum] Schema Comparison from SDXML Source Cannot do Column Level Grants
Schema Comparison from SDXML Source Cannot do Column Level Grants
Thread created by chazamania
Steps to reproduce on 12.1 (same issue in 11.6 generated file using 11.6).1. Do DB to DB comparison of just grants and create a schema snapshot file. My sample grants identical on both sides:
GRANT SELECT ON SCOTT.TABLE TO ROLE_VIEWER;
GRANT UPDATE (COL1) ON SCOTT.TABLE TO ROLE_VIEWER;
Observe no diffs in the results
Change source to newly generated snapshot file.
Compare and diffs report GRANT UPDATE (COL1) ON SCOTT.TABLE TO ROLE_VIEWER
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.