Alexandr Ustinov
Member
It will be great to have ability to classify connections (using lists of TNS specs, with regexes), to distinguish production databases and development/testing ones.
For production databases we need to allow SELECTs and ALTER SESSION commands only by default, any DELETEs, UPDATEs, any DDL or CREATE OR REPLACE should lead to special dialog window, which will ask for privilege escalation, even if the connected user has all the DBA/schema owner privileges.
The feature should work just like Windows UAC does - even if you do have all the administrator rights - some actions will require explicit prompt and confirmation.
Such feature could allow to do not paste/execute code into wrong window, it would be especially useful in Multiconnection mode, when it's very easy to miss the proper window and to make disruptive change for working system.
For production databases we need to allow SELECTs and ALTER SESSION commands only by default, any DELETEs, UPDATEs, any DDL or CREATE OR REPLACE should lead to special dialog window, which will ask for privilege escalation, even if the connected user has all the DBA/schema owner privileges.
The feature should work just like Windows UAC does - even if you do have all the administrator rights - some actions will require explicit prompt and confirmation.
Such feature could allow to do not paste/execute code into wrong window, it would be especially useful in Multiconnection mode, when it's very easy to miss the proper window and to make disruptive change for working system.
