Re: privilege and role to view all object in own schema

Users can always 'see' objects in their own schemas which they own.

Best route is to put the objects in another schema and grant 'select' privileges on the objects (and use synonyms to make them schema transparent) for the users you want to have access to them. Users cannot use objects that are not in their schema that they don't have privileges on, so you second question is OK.

If you really do want to 'freeze' things, try putting them in a tablespace and making it 'read-only' once the objects have been created and loaded with data.

Steve Phelan (UK)

Starous wrote in message <34FAF559.5DDA5173_at_pluto.spsselib.hiedu.cz>...
>Hi all Oracle Gurus
>
> I found problem, as usual. I need grant some roles and privilege
> to some user. I want user to see all objects in his schema (
> packages, tables, data in tables ...) without any possibility to
 change
>thos data, and I want him to not see object from other schemas
> in the same database.
>
>
> Thanks to you,
>
> Starous
Received on Mon Mar 02 1998 - 00:00:00 CST