Hey Mike, TOAD comes to mind (http://www.toadsoft.com for a free trial version), = although just about any GUI tool I can think of will let you fire up a = script window to write and execute your own DDL, obtrusive or otherwise. = TOAD allows a DBA to place restrictions on what GUI features a TOAD = user can access, but it will never disallow access to the SQL Editor = (text) window, because that feature of TOAD is basically a GUIfied = version of SQL*Plus. HTH! Enjoy! Rich Rich Jesse System/Database Administrator rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA -----Original Message----- Sent: Thursday, November 04, 2004 12:34 PM Subject: Query tool We are looking for a gui-based tool to let our users/developers run = query and possibly dml on databases, but not allow ddl changes or other = intrusive commands. I already know about Oracle Discoverer. Mike Kurth -- //www.freelists.org/webpage/oracle-l