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

[Orlando Amador]

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

[Ana C. Dent]

"Orlando Amador" <oa*****@obipr.jnj.com> wrote in
news:cl********@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.