470,614 Members | 1,429 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

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



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


Jul 19 '05 #1
1 3241
"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.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Amardeep Verma | last post: by
2 posts views Thread by virgilio | last post: by
31 posts views Thread by Michael C | last post: by
1 post views Thread by Troels Arvin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.