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 - 21:16:44 CEST