From: anacedent@hotmail.com   
      
   "Orlando Amador"  wrote in   
   news: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   
      
   ROLES are not used by PL/SQL procedures.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)