Grant without privilege in 12c after upgrade from 11g

jfglade

GRANT ON crddata.crddata TO "PUBLIC";

I upgraded a copy of an Oracle 11g database and then ran the Schema Compare tool on the CRDDATA schema between the 11g and 12c databases. The above grant is listed in the 12c database without the privilege listed, it is simply 2 blanks between GRANT and ON.

Is this supposed to be the GRANT INHERIT PRIVILEGES?

richardjm

Having a look through the code I think you are correct. We attempt to parse the privilege information into an enum but when it encounters something it doesn't recognise it default to "none" which returns the blank string you are seeing.

I'll take a look into it and see if I can get you a branch that helps. We've not done much work on 12c but aim to be responsive to issues that people hit so this is very useful for us (and everybody who uses 12c in the future).

richardjm

Right, I believe I've replicated the issue and fixed it.

If you can try the latest bugfix release and see if that helps.

ftp://support.red-gate.com/patches/Sche ... 5fd341.zip