Re: Rollback segments

In article <505nv0$1kdu_at_elmo.cadvision.com>,

        gouldent_at_cadvision.com (Ted Goulden) writes:
>
>A rollback segment is just another ORACLE object like a table or view.

Huh??? It is a standard database object, reserved for the RDBMS engine itself.

>Use REVOKE to restrict access to a segment. I am assuming that you are
>intending to do this with a special segment not the SYSTEM rollback
>segment; this would not be a good idea.

What access privileges can be granted, explicitly or implicitly against a rollback segment. The only ones I'm aware of are CREATE and DROP (DDL), not INSERT, UPDATE, DELETE (DML).

Bill Received on Fri Aug 30 1996 - 00:00:00 CEST