REMOVING INSERT, DELETE, UPDATE FUNCTIONALITY

[geetter@UHAVAX.HARTFORD.EDU]

I am a new SQR user and would like to know how, if possible, to prevent
almost all SQR users from inserting, deleting or updating data via SQR.  All
users are assigned ORACLE table grants via ROLES and these roles do have
grants to many tables that include INSERT, DELETE, and UPDATE.  The grants
are necessary to use ORACLE FORMS in our systems and use of the FORMS through
a FORMS security interface controls our users in there ability to use the
FORMS in query mode only or update mode.  These underlying grants leave us
vulnerable to uses being able to write SQR processes which could update,
delete or add data to our database.  On the other hand, we do want this
funtionality for our development staff.

Another question I have is, is there a way to allow only specific accounts
to have access to SQR?

Please answer direcdtly if you prefer to geetter@uhavax.hartford.edu .  Any
help would be most appreciated.

Allan Geetter
Data Security Administrator
University of Hartford
West Hartford, CT 06117
Voice (860) 768-4889
FAX   (860) 768-4907