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

From: Orlando Amador <oamador_at_obipr.jnj.com>
Date: Fri, 22 Oct 2004 15:16:44 -0400
Message-ID: <clbmat0clh@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 Received on Fri Oct 22 2004 - 14:16:44 CDT