It is quite an annoying thing when you copy DDL generated code for a table in Oracle SQL Developer and you forget GRANTS. This is because in SQL Developer GRANTS are not showed by default.
To show permissions in the code, you have to change the default settings of the product.
In the
Tools -> Preferences, locate the
Database -> Export node and tick the "
Grants" option.
Nessun commento:
Posta un commento