Create a read only connection
Hi all, Do you know if it's possible (and how) to create a read only connection. It's possible with SQL Tools. You can create a connection that will fordid you to launch any update / create request (or an option that will warn you or something). It's very useful when you work with many environments (production / test) and sometimes you can just launch a alter request in the wrong environment (already happened to me ones... not good). thanks.
I'm not aware of anything in SQL Developer that would achieve what your asking for. Sounds like you want to 'deny' any commands which contain "create", "drop" etc. Normally I think this would be done through privileges granted to the user - you create a user that has only SELECT privs, and use this when you are connecting to the production environment. If you don't want to start logging in with a new user, perhaps you could assign a default role to your current user which limits your actions.
I can not ask for the creation of another user in the DB with read only access. But I thought that maybe there was such a feature in SQL Dev as there is one in SQL Tools (wich I don't use because I don't like the interface). It's quite too bad, and could maybe be a good feature to add in the next version. Thanks anyway for the quick answer. ;)
There are several requests for this on the SQL Developer Exchange. Vote on them to add weight for possible future implementation (however several were rejected already). Regards, K.
I just have another question concerning the same problem
IS there a way to change the presentation depending on wich connection I am. For exemple if am working on my "dev" connection the background of the window will be green and if I am working on the "prod" connection it will be red. So that I am warn if I am going to do something wrong in the prod environement. Do you think this is possible??
That's yet another existing request on the SQL Developer Exchange. Go vote to add weight for possible future implementation. Regards, K.
hi, the easiest way is to set prompt in sqlplus (if you use). Go to global login script called glogin.sql in the $ORACLE_HOME/sqlplus/admin directory. Put on PROD: SET SQLPROMPT '&_USER.#&_CONNECT_IDENTIFIER.-PROD!!!> ' alike on DEV instance. Also it is useful to have to aliases (under linux) with different attributes of the window of their sessions. set alias sqlprod=".........eg. set new name in the head of window; call the seesion; rollback to previous name" or under windows alike - change Properties of the background color, and so on...
Using REF with object table in SQL Developer
Custom Reports in SQL Developer and translations files
Inserting in VIEW does not work in GUI
EA2 - invalid option for ALTER SESSION when logging in to 9i DB via EA2
Issue regarding display
Sql developer 2.1 error messages
SQL Developer and instantClient in iMac
Source does not have a runnable target
SQL Developer 2.1 EA2 does not show any procedures
SQL Developer 2.1 EA2 and Version Control issue
SQL Developer 2.1 EA2 issue with TNS connections
Where is the MySQL JDBC driver file?
Issue with viewing packages in SQL Developer EA2
Bug tracking in Sql Developer (stable and EA ver.)
SQL Dev with DB2 and Sybase