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 -> GRANT SELECT to sys.dba_*

GRANT SELECT to sys.dba_*

From: Dominic Lancaster <landom_at_bimberi.com.au>
Date: 1998/06/12
Message-ID: <3581132C.2E27@bimberi.com.au>#1/1

Can someone help me with the syntax to allow me to set what is essentially read access only for one 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 - 00:00:00 CDT

Original text of this message

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