RE: VIEWS/ROLES/PRIVS

Sue also needs the CREATE ANY VIEW system privilege.

Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Charlie_Mengler_at_HomeDepot.com [SMTP:Charlie_Mengler_at_HomeDepot.com]
>
> I'm just doing a sanity test on my befuddled brain.
>
> I have a schema owner called JOE which owns a bunch of tables.
> While logged into the instance as JOE, he does the following -
> SQL> GRANT SELECT ON BASE_TABLE TO STD_ROLE;
> While logged into the instances as SYS, I do the following -
> SQL> GRANT STD_ROLE TO SUE;
> Now when SUE logs into the instance she want to create a view
> in her own schema based upon JOE.BASE_TABLE.
>
> The problem is that Oracle spits an ORA-01031 error and
> reports that SUE does not have sufficient privs.
>
> Other than explicitly doing
> SQL> GRANT SELECT ON BASE_TABLE TO SUE;
> is there any way to allow SUE to create the view?
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Whittle Jerome Contr NCI
  INET: Jerome.Whittle_at_scott.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).