While generating the DDLs for the table you can also generate the REST services for the table easily.
To generate the DDL select File, Export, DDL File.
Then select the RDBMS Site and the relational model wanted and press Generate.
Select Generate REST Services.
And the script now not only includes the table generation (and whatever else you chose) but also REST enabling scripts.
P.S. If you want to isolate the tables from users with views, you can easily create a view for a table (and then grant privileges to views instead of tables). Just like described above you can create the REST services for views as well.
To create the views for tables select Tools, Table to View Wizard.
Select the tables wanted.
And then generate the DDLs as described.
Hi Heli,
Hope you are doing good.
We are trying to set UDPs for tables and columns in SDDM using scripting.
We have tried setProperty method which is for dynamic properties.
Could you please let me know any method to set UDPs using scripting?
Thanks,
Neetesh
Hi! setProperty should work. https://community.oracle.com/tech/developers/discussion/4486046/what-are-the-functions-used-for-adding-column-level-and-table-level-udps#latest
Best regards
Heli