Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Q: privilege and role to view all object in own schema

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

From: Starous <starek_at_pluto.spsselib.hiedu.cz>
Date: 1998/03/02
Message-ID: <34FAF559.5DDA5173@pluto.spsselib.hiedu.cz>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US