VIEWS/ROLES/PRIVS

From: <Charlie_Mengler_at_HomeDepot.com>
Date: Fri, 01 Nov 2002 09:28:49 -0800
Message-ID: <F001.004F9FC6.20021101092849@fatcity.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:
  INET: Charlie_Mengler_at_HomeDepot.com

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). Received on Fri Nov 01 2002 - 11:28:49 CST