Re: Why would explicit system privileges work and inherited through a role fail?

"Orlando Amador" <oamador_at_obipr.jnj.com> wrote in news:clbmat0clh_at_news1.newsguy.com:

>
>
> We have a web application, which uses ASP.NET and ADO.Net to access
> the Oracle 9.2 database. The application was issuing an ORA-01031
> 'insufficient privilege' when creating a table. The oracle account
> used to connect to the database has CONNECT and RESOURCE roles. It
> also has unlimited table space.
>
>
>
> Just for testing I granted the create table system permission to the
> user and the error was resolved.
>
>
>
> So my question is, since the create table is already assigned to the
> resource role, shouldn't this user already have the ability to create
> table implicitly? Why do we need to explicitly grant this system
> permission? Is this a know problem with Oracle?
>
>
>
> Any sugestions?
>
>
>
> Saludos,
>
> Orlando

ROLES are not used by PL/SQL procedures. Received on Sat Oct 23 2004 - 03:08:38 CEST