Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBMS_SQL to Create views

RE: DBMS_SQL to Create views

From: Kevin Lange <>
Date: Mon, 24 Sep 2001 11:14:42 -0700
Message-ID: <>

I am
creating a package owned by PCM$ but compiling it by SYS.    I thought that by compiling it by SYS the users running it would have all the authority they needed to Create the views that the package creates.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Koivu, Lisa   []Sent: Monday, September 24, 2001   1:17 PMTo: Multiple recipients of list ORACLE-LSubject:   RE: DBMS_SQL to Create views
  Hi Kevin, this is kind of changing the   topic... but why are you creating procedures as SYS?? Seems to me upgrades,   patches, etc. would possibly endanger your procedure.  I always thought   of it as sys owning all the code that runs the database, data dictionary, etc.   and user code belonged somewhere else.    Sorry I'm not answering your question but   posing another.
  Lisa Koivu Oracle Database
  Administrator Fairfield Resorts, Inc.   954-935-4117   

    -----Original Message----- <FONT
    face=Arial size=1>From:   Kevin
    Lange [] <FONT face=Arial     size=1>Sent:   Monday,
    September 24, 2001 1:40 PM <FONT face=Arial

    size=1>To:     <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
    size=1>Subject:        <FONT 
    face=Arial size=1>RE: DBMS_SQL to Create views 
    I had originally created the Procedure under SYS     after first having PCM$ granting SELECT     explicitly on the tables involved.  I made sure SYS could     CREATE ANY VIEW .
    On both the DEV and the TEST instances I DIRECTLY     granted select on the tables to the     ID   RRS.
    On the DEV instance RRS can run the procedure and     it will create the view.
    On the TEST instance RRS gets the error of     Insufficient privileges .
    I thought maybe it was that RRS could not run the     DBMS_SQL routines so I granted execute     directly from sys to RRS on those.   No dice.     I am STUMPED at this point.
    -----Original Message----- <FONT
    face=Arial size=2>Sent: Monday, September 24, 2001 12:16 PM <FONT     face=Arial size=2>To: Multiple recipients of list ORACLE-L     Have you granted explicitly to the user ?. How     about AUTHID ?. Have you created the     procedure with the default value of this     clause ?.
    Regards. Received on Mon Sep 24 2001 - 13:14:42 CDT

Original text of this message