Hi
Is there a way to connect in a "Read only" mode ? just to be sure user will not drop any objects (tables, index ...) or tablespace ? without creating dedicated oracle users with specific roles ?
This is currently not possible. In version 6.0 you will have a PL/SQL Developer privilege table where you can define on a role and user basis which functions are available.
