SQL Developer


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...

Related Links

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
git support?
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

Categories

ORACLE DEV
WebCenter Content
Collaboration Suite Ar...
Discrete Manufacturing
Personalization
XQuery
Install (Korean)
OPS/RAC (Korean)
NLS (Korean)
Discoverer (Korean)
Oracle Clusterware
Oracle Virtualization
Advanced Compression
Tuxedo Systems and App...
iStore
weblogic.developer.int...
Workshop Product Famil...
BEA SALT
Composite Applications
weblogic.network.gatek...
Archived Discussion Fo...
Primavera Contractor
WebLogic Server - Perf...
Complex Event Processing
WebLogic Server - JMS
Oracle Policy Automation
JavaServer Pages (JSP)...
Java Platform Debugger...
Sun Java System Identi...
Java Virtual Machine (...
JavaHelp System [ARCHIVE]
Java Advanced Imaging ...
Internationalization (...
Java Game Development
New To Java Technology...
Java Real-Time
Sun Java Desktop System
General Java Developme...
バックアップ・リカバリ
Database Migration Ass...
プログラミング一般
Multitenant
Oracle WebCenter/Oracl...
Oracle Mobile
Oracle Labs
Architecture - General...
Oracle Developer Cloud...
Enterprise Metadata Ma...
Node.js
Throwback Thursday
Colorado Eloqua Users
Ohio & Kentucky Eloqua...
United Kingdom User Group
Pittsburgh, PA Eloqua ...
Oracle Integration Clo...
Systems Track
OMC - Industry Solutio...
...
Oracle Mobile Cloud Se...
Oracle Virtual Networking
Global Trade Management
Java SE Snapshots: Pro...
POUG
Coming Soon - Oracle A...
ilOUG - Israel Oracle ...
Korea Engineered Syste...
Netra Servers
JavaScript - Nashorn
Synopsis
Marketing Elo[q]ution ...
Containers
Containers, Docker, an...
North Central Oracle A...
Oracle Systems Manager...
Chart of the Week
Cúpula Virtual de Tecn...
Modern Marketing Eloqu...
Oracle Database Develo...
Enterprise Resource Pl...
Database Security - Ge...
Sales and Marketing
Business Intelligence ...
Database - General (Ko...
Security
开发工具
Archived Newsgroups
weblogic.eventserver.g...
J2ME Development (Chin...
Other Sun Hardware
AutoVue Integrations
Endeca Information Dis...
OTN ArchBeat Podcast

Resources

Database Users
RDBMS discuss
Database Dev&Adm
javascript
java
csharp
php
android
javascript
java
csharp
php
python
android
jquery
ruby
ios
html
Mobile App
Mobile App
Mobile App