Re: REMOVING INSERT, DELETE, UPDATE FUNCTIONALITY

["Jeff T. Orwick [C]" <orwick@CIG.MOT.COM>]

RE: Your second question.

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

If you're on unix only give access execute sqr to the unix groups you want to
have those privelages.

As for your first question your DBA may be able to restrict access based on the
tool accessing the data-base.  I seem to remember that ability at some level
covered in an Oracle 6 DBA class.  I don't think you could specifiy
restrictions to update, delete, etc. at the table level, AND I don't know if
that functionality extended to third party products or not.

--
Jeff T. Orwick            orwickj@tusc.com <- Full time address
http://www.tusc.com