5 Replies Latest reply: Dec 7, 2012 8:50 AM by 59640 RSS

    OID users ( EUS) problem with grant create table with admin


      We activated enterprise users in the OID.

      There is a role APP_ADMIN that has the following grants:

      create user
      drop user
      create table with admin option

      this is for an application that creates BI schemas, so it needs to be able to create other users.

      I have granted these to a local role, and the user has access to the local role, thanks to the OID setup.
      The create and drop user work.
      however, the grant create table to another user does not work.

      Is there an issue with 'with admin option' grants in Enterprise user security?