I believe that to create a view on another user's tables, you need to
have been granted (directly, not via a role) select WITH GRANT OPTION
on the tables. Have you checked that?
Paul Baumgartel
- Kevin Lange <kgel_at_ppoone.com> wrote:
> I made sure all my authorities on everything that I thought they were
> required on was set. But I am still getting the errors below.
>
> Does anyone have any ideas why the error would be occuring ?? I
> really need
> to get this fixed.
>
> Kevin
>
> -----Original Message-----
> Sent: Friday, September 21, 2001 3:25 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Gang;
> I have a piece of SQL that generates a SQL statement that will
> create a
> view for a user.
>
> On our DEV machine the user can use it just fine. But, on our Test
> machine
> they keep getting the error :
>
> ERROR at line 1:
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 491
> ORA-06512: at "SYS.DBMS_SQL", line 32
> ORA-06512: at "PCM$.CALCFEESCHEDGETDATA", line 71
> ORA-06512: at line 1
>
> I looked at all the security I could think of:
> select on all the mentioned tables by the owner
> select any table granted by sys
> create view granted by sys
> create any view granted by sys
> execute on dbms_sql and dbms_sys_sql granted by sys
>
> Nothing works.
>
>
> HELP.--------- Any suggestions on where to go now ??
>
> Thanks
>
> Kevin
>
> -----Original Message-----
> Sent: Friday, September 21, 2001 2:17 PM
> To: Multiple recipients of list ORACLE-L
>
>
> How are your permissions?
>
>
>
>
>
> jacinth
>
> <jacinth To: Multiple recipients
> of list
> ORACLE-L
> @mail.ev1.net <ORACLE-L_at_fatcity.com>
>
> > cc:
>
> Sent by: root Subject: setting up
> HACMP and
> Oracle 8.1.6
>
>
>
>
> 09/21/2001
>
> 02:20 PM
>
> Please
>
> respond to
>
> ORACLE-L
>
>
>
>
>
>
>
>
>
> I hope someone may be able to shed some light on this. Oracle does
> not
> seem to have much information on setting up failover on HA, other
> than
> OPS (which we are not doing). I am not an HA expert, so I may just
> be
> missing something or not asking right questions.
>
> HW: IBM S7A
> OS: AIX 4.3.3
> Oracle 8.1.6
>
> Scenario: Two nodes, one set up production, the other test/batch.
> We
> are trying to configure so that when production goes down, it fails
> over
> to node B, shutting down test/batch in process. Oracle is installed
> on
> each node, but in different directories.
>
> Problem: On failover to node B, there are problems starting up DB,
> and
> a noteable failure to start the listener. Listener log not much
> help.
> HACMP log shows:
>
> Could not load program oracleeml:
> Dependent module libobk.a(shr.o) could not be loaded.
> Could not load module libobk.a(shr.o).
> Error was: No such file or directory
>
> The file does exist.
>
> Anyone have ideas?
>
>
> -Denise Horton-
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: jacinth
> INET: jacinth_at_mail.ev1.net
>
> 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).
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: tday6_at_csc.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_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
> INET: kgel_at_ppoone.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_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kevin Lange
> INET: kgel_at_ppoone.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_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).
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger.
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: treegarden_at_yahoo.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_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 Mon Sep 24 2001 - 12:34:02 CDT
