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

Home -> Community -> Usenet -> c.d.o.server -> Grant select on 'sys.dba_*'

Grant select on 'sys.dba_*'

From: Dominic Lancaster <dominic_at_bimberi.com.au>
Date: Fri, 12 Jun 1998 21:42:14 +1000
Message-ID: <35811416.2DD6@bimberi.com.au>


Could someone please help me grant what is essetially read only access for a user to the 'sys.dba_*' tables, I was thinking of:
GRANT SELECT ON TABLE like 'sys.dba%' TO USER;

Would this work?

TIA Received on Fri Jun 12 1998 - 06:42:14 CDT

Original text of this message

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