Re: roles on oracle 8

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 7 Sep 2000 23:12:08 +0200
Message-ID: <968362608.27901.0.pluto.d4ee154e@news.demon.nl>

Roles didn't change. What is *exactly* going wrong?

Regards,

Sybrand Bakker, Oracle DBA

"Eleanor" <ele_at_mit.edu> wrote in message news:39B80092.A0C3FE06_at_mit.edu...
> hi,
>
> we just switched from oracle 7.3 to oracle 8.1.6 and we are having
> problems with roles. The
> application (a powerbuilder app) is crashing. Is there some difference
> in the way oracle 8 handles roles
> and privileges?
>
> we create a role (call it 'superRole').
> grant create session to superRole.
> grant superRole to individual users.
> grant execute on all our stored procedures to superRole.
>
> this works fine in oracle 7, but in oracle 8 it seems like we have to
> grant dba to superRole - which we
> don't want to do, because then all the user's would have dba privs ,
> correct?
>
> thanks,
> Eleanor
>
>
>
Received on Thu Sep 07 2000 - 16:12:08 CDT