From charliem@mwh.com Wed, 28 Mar 2001 12:13:16 -0800 From: "Charlie Mengler" Date: Wed, 28 Mar 2001 12:13:16 -0800 Subject: ORA-01031: insufficient privileges Message-ID: MIME-Version: 1.0 Content-Type: text/plain Solaris V2.6 Oracle V8.1.8 Previously I logged in as username "HR" & did SQL> GRANT SELECT ON EMPHEADER_MASTER TO BCM; Within a PL/SQL package the following lines exits. EXECUTE IMMEDIATE 'TRUNCATE TABLE HR_EMP'; EXECUTE IMMEDIATE 'DROP TABLE HR_EMP'; EXECUTE IMMEDIATE 'CREATE TABLE HR_EMP TABLESPACE USERS STORAGE ( INITIAL 128K NEXT 128K) UNRECOVERABLE AS SELECT * FROM HR.EMPHEADER_MASTER'; The procedure bombs with ORA-01031: insufficient privileges on the CTAS line. I (schema BCM) own the procedure & execute it. I can manually (from SQL*PLUS) successfully cut, paste & run the CREATE TABLE ... AS... Any advice on how to make the error go away & get the table created would be greatly appreciated -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: charliem@mwh.com 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@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).