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 -> Re: Limit a role to a schema...

Re: Limit a role to a schema...

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Fri, 17 Feb 2006 02:47:56 GMT
Message-ID: <Xns976CBF54053C4ianalvistahotmailcom@70.169.32.36>


"heizer1_at_llnl.gov" <heizer1_at_llnl.gov> wrote in news:1140137113.703129.74150 @g14g2000cwa.googlegroups.com:

> Hi, is there an easy way to create a role which has select privledges
> to any table within a schema?
>

EASY is a relative term.
It is easy for me to write SQL which writes SQL to accomplish the above. If it is easy for your is left as an excerise for you to complete on your own. Received on Thu Feb 16 2006 - 20:47:56 CST

Original text of this message

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