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: Granted Role privileges not working

Re: Granted Role privileges not working

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 12 Jul 2002 00:32:25 +0200
Message-ID: <5o1siuk2rciicdm1j92l1b66jaq77td7ji@4ax.com>


On Thu, 11 Jul 2002 23:00:16 +0100, "michael.cooke" <michael.cooke_at_tinyworld.co.uk> wrote:

>Currently running Oracle 7.3.3 NT4 SP3
>Developer 2000 Forms 4.5 reports 2.5
>have come across aa couple of occurences where table privileges will not
>work in a role only when granted directly to the user.
>has anyone else come across this problem? is it documented any where? or is
>it likely to be a problem with our application?
>
>thanks for any constructive suggestions
>

usenet is flooded with answers on this one

roles are volatile so they are ignored when compiling sp's

regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jul 11 2002 - 17:32:25 CDT

Original text of this message

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