Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: View creation error on a table with grant through a role?

RE: View creation error on a table with grant through a role?

From: Szecsy Tamas <tszecsy_at_GEOMETRIA.hu>
Date: Thu, 04 Apr 2002 06:23:38 -0800
Message-ID: <F001.0043B23D.20020404062338@fatcity.com>


I have the grant via a role. You can not grant to a role with grant option!

Tamas

-----Original Message-----
Sent: Thursday, April 04, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L

you need grant with admin option for creating view on a table owned by someone else.

Raj



Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Szecsy Tamas
  INET: tszecsy_at_GEOMETRIA.hu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Thu Apr 04 2002 - 08:23:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US