This discussion is archived
5 Replies Latest reply: Dec 7, 2012 6:50 AM by 59640 RSS

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

59640 Newbie
Currently Being Moderated
Hi,

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?


Regards,

Peter

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points