roles on oracle 8

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 - 15:54:42 CDT