Database Export - Grants
I was wondering if I'm simply not getting this right or there is something I'm missing. When I use the Database Export tool and select Export DDL including the check job for grants and no data when I get the ddl back it has the sql to create the table but the sql for the grants is not in the text. I know the table has grants because I can see them in the on the table when I highlight the table. I have noticed the same behavior with materialized view in the ddl is created but the grants statements are not provided. Just wondering if I missing something or should the grant statements be generated.
Thanks,