Oracle 10.2.0.4
I am moving a database from one server to another using expdp and impdp. This database services a third-party app that makes use of PUBLIC Synonyms pointing to SYS objects (I know, I know). The impdp does not bring in grants to public. It seems like it would be an easy thing to do, write a sql script to generate the grants and then run it. For the life of me, I can't find where these are stored. From TOAD I can see the grants on the object in the source database, but every DBA_ table that I look at for privs don't include these. Even going to TOAD and doing a generate scripts (on database or schema) and using the checkbox 'grants' don't give me the grants.
What am I missing?