Re: How to restrict visibility of report/form user

Victor,

   Not much of a back door really, since the user cannot access the data within these schemas. SQL*PLUS users have the same information available to them (more detailed, though not as neatly presented) via views like ALL_TABLES, ALL_TAB_COLUMNS, ALL_CONSTRAINTS, ALL_INDEXES, ALL_TRIGGERS, ALL_USERS, ALL_VIEWS, etc. Paul

In article <383F621A.42D1A1A0_at_erols.com>,   vs <slootsky_at_erols.com> wrote:
> Oracle Developer user can see (in Database Objects node of Object
> Navigator) all schemes, including SYS and SYSTEM, and even their
> objects' structure. It is like a back door to the restricted area
where
> nobody checks any ID.
>
> How to restrict user, so only his/her schema will be visible to
> him/her ?
>
> Victor
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Nov 27 1999 - 12:42:26 CET