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.
lunedì 13 ottobre 2014
Oracle Tip: enabling GRANTS in SQL generation in Oracle SQL Developer
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.
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.
Iscriviti a:
Post (Atom)