For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Hello,
When I add privileges to a table, in the DDL I have this code:
GRANT DELETE, INSERT, REFERENCES, SELECT, UPDATE ON my_table TO my_user WITH GRANT OPTION;
How can I create the same code without WITH GRANT OPTION ?
Well, it's easier (one click less) than the code with grant option - permissions can be defined at object level and at user level and it's obvious if you look at dialogs:
Philip
Merde Philip!!!
Before my eyes!
Sorry, I'm very stupid.
Hello Philip, is there a possibility to pull / synchronize these rights(WITH GRANT OPTION) from the database and not set it manually? My usecase is. I would like to generate the data modeler from the database and then generate the scripts from the data modeler and import this into another environment.