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: Privilege problem

Re: Privilege problem

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 20 Aug 2003 19:21:05 +0200
Message-ID: <aeb7kv0ohrafsn28juah1e9s48kqdu37l0@4ax.com>


On Wed, 20 Aug 2003 15:16:09 +0200, "Steven" <SPAMBLOCKERsteven.pannell_at_gmx.net> wrote:

>Why can't I assign 'query rewrite' to a role. can someone tell me what I am
>doing wrong.

Nothing. As roles are volatile they are ignored during compilation of stored objects. Views are compiled. This is just the way it works.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Aug 20 2003 - 12:21:05 CDT

Original text of this message

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