SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer read-only access

SFNYCMar 23 2006 — edited Nov 16 2006

Is there a way to give SQL Developer read-only (select) access to a database? One concern at my company is that developers may accidentally access the production database and issue truncates or deletes on the production tables. Is there a way to make connections to a certain database read-only? Is there a parameter in the tnsnames.ora file? Something similar was done on our PC when we use the GUI SQLPlus where the delete command was disabled. Is there something similar?

Sam

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 14 2006

Added on Mar 23 2006

#sql-developer

7 comments

2,189 views