In our company we use TOAD. We can save a fair amount of licensing fees if we switch to SQL Developer.
Within TOAD, for each database we can enforce the read only modus of TOAD. A TOAD specific table in the database is populated with a list of database users and roles that are not allowed to mutate data using TOAD, regardless the object privileges a user needs while using the intended application.
Is there any similair mechanism within SQL Developer, and if so, how do I implement it?
Kind regards,
Andre