Re: Rollback segments

A rollback segment is just another ORACLE object like a table or view. 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.

Terry Walker <terryw_at_kgf.com> wrote:

>How do I prevent a user from using certain rollback segments?
>Thanks in advance.
>--
>============================================================================
>Terry Walker Internet: terryw_at_kgf.com
>Kraft Foods twalker_at_kraft.com
>250 North Street N1-3
>White Plains, NY 10625
>(914) 335-4385 Fax - 2015 "I'm not paranoid, everyone IS out to get
>me!"
>============================================================================
Received on Fri Aug 30 1996 - 00:00:00 CEST