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
[mailto:lisa.koivu_at_efairfield.com]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 [SMTP:kgel_at_ppoone.com] <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.
Kevin
-----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.
- 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 <FONT face=Arial
size=2>> errors below. >
> Does anyone have any ideas why the
error would be > occuring ?? I
really need > to get this
fixed. > <FONT face=Arial
size=2>> Kevin > <FONT
face=Arial size=2>> -----Original Message----- <FONT
face=Arial size=2>> Sent: Friday, September 21, 2001 3:25 PM
> To: Multiple recipients of list
ORACLE-L > <FONT face=Arial
size=2>> > Hi Gang;
> I have a piece of SQL that
generates a SQL > statement that will
create a > view for a user.
> <FONT face=Arial
size=2>> 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 <FONT face=Arial
size=2>> ORA-06512: at "PCM$.CALCFEESCHEDGETDATA", line 71
> ORA-06512: at line 1 <FONT
face=Arial size=2>> > I looked at
all the security I could think of: <FONT face=Arial
size=2>> 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 <FONT face=Arial
size=2>> execute on dbms_sql and dbms_sys_sql granted
by > sys <FONT face=Arial
size=2>> > Nothing works.
> >
> HELP.--------- Any
suggestions on where to go now >
?? > <FONT face=Arial
size=2>> Thanks > <FONT
face=Arial size=2>> Kevin >
> -----Original Message-----
> Sent: Friday, September 21, 2001 2:17
PM > To: Multiple recipients of list
ORACLE-L > <FONT face=Arial
size=2>> > How are your
permissions? > <FONT
face=Arial size=2>> >
> <FONT face=Arial
size=2>> <FONT face=Arial
size=2>>
jacinth > <FONT face=Arial
size=2>>
<jacinth
To: > Multiple
recipients of list >
ORACLE-L <FONT face=Arial
size=2>>
@mail.ev1.net <FONT
face=Arial size=2>> <ORACLE-L_at_fatcity.com> <FONT
face=Arial size=2>> <FONT face=Arial
size=2>>
>
cc: > <FONT face=Arial
size=2>>
Sent by: root Subject:
> setting up HACMP and
> Oracle 8.1.6
> <FONT face=Arial
size=2>> > <FONT
face=Arial size=2>> <FONT face=Arial
size=2>>
09/21/2001 > <FONT
face=Arial
size=2>>
02:20 PM > <FONT face=Arial
size=2>>
Please > <FONT face=Arial
size=2>>
respond to > <FONT
face=Arial
size=2>>
ORACLE-L > <FONT face=Arial
size=2>> > <FONT
face=Arial size=2>> >
> <FONT face=Arial
size=2>> > <FONT
face=Arial size=2>> > I hope
someone may be able to shed some light on <FONT face=Arial
size=2>> this. Oracle does not <FONT face=Arial
size=2>> seem to have much information on setting up failover
> on HA, other than <FONT
face=Arial size=2>> OPS (which we are not doing). I am not an
HA > expert, so I may just be
> missing something or not asking right
questions. > <FONT
face=Arial size=2>> HW: IBM S7A <FONT face=Arial
size=2>> OS: AIX 4.3.3 >
Oracle 8.1.6 > <FONT
face=Arial size=2>> 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: <FONT face=Arial
size=2>> 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 > <FONT
face=Arial size=2>> The file does exist. <FONT face=Arial
size=2>> > Anyone have
ideas? > <FONT face=Arial
size=2>> > -Denise Horton-
> -- >
Please see the official ORACLE-L FAQ: <FONT face=Arial
size=2>> <A href="http://www.orafaq.com"
target=_blank>http://www.orafaq.com <FONT face=Arial
size=2>> -- > Author:
jacinth > INET:
jacinth_at_mail.ev1.net >
> Fat City Network
Services -- (858) 538-5051 FAX: <FONT
face=Arial size=2>> (858) 538-5051 <FONT face=Arial
size=2>> San Diego, California
- Public Internet > access / Mailing
Lists > <FONT face=Arial
size=2>--------------------------------------------------------------------
> 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). > <FONT
face=Arial size=2>> > --
> Please see the official ORACLE-L
FAQ: > <A href="http://www.orafaq.com"
target=_blank>http://www.orafaq.com <FONT face=Arial
size=2>> -- > Author:
> INET:
tday6_at_csc.com > <FONT
face=Arial size=2>> Fat City Network Services -- (858)
538-5051 FAX: > (858)
538-5051 > San Diego,
California -- Public
Internet > access / Mailing
Lists > <FONT face=Arial
size=2>--------------------------------------------------------------------
> 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). > -- <FONT
face=Arial size=2>> Please see the official ORACLE-L FAQ:
> <A href="http://www.orafaq.com"
target=_blank>http://www.orafaq.com <FONT face=Arial
size=2>> -- > Author: Kevin
Lange > INET:
kgel_at_ppoone.com > <FONT
face=Arial size=2>> Fat City Network Services -- (858)
538-5051 FAX: > (858)
538-5051 > San Diego,
California -- Public
Internet > access / Mailing
Lists > <FONT face=Arial
size=2>--------------------------------------------------------------------
> 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). > -- <FONT
face=Arial size=2>> Please see the official ORACLE-L FAQ:
> <A href="http://www.orafaq.com"
target=_blank>http://www.orafaq.com <FONT face=Arial
size=2>> -- > Author: Kevin
Lange > INET:
kgel_at_ppoone.com > <FONT
face=Arial size=2>> Fat City Network Services -- (858)
538-5051 FAX: > (858)
538-5051 > San Diego,
California -- Public
Internet > access / Mailing
Lists > <FONT face=Arial
size=2>--------------------------------------------------------------------
> 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).
- Eng.
Christian Trassens Senior DBA
Systems Engineer <FONT face=Arial
size=2>ctrassens_at_yahoo.com <FONT face=Arial
size=2>ctrassens_at_hotmail.com Phone :
541149816062
<FONT face=Arial
size=2>__________________________________________________ <FONT
face=Arial size=2>Do You Yahoo!? Get
email alerts & NEW webcam video instant messaging with Yahoo!
Messenger. <A href="http://im.yahoo.com"
target=_blank>http://im.yahoo.com --
Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com" target=_blank>http://www.orafaq.com
- Author:
Christian Trassens INET:
ctrassens_at_yahoo.com
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 <FONT face=Arial
size=2>San Diego, California --
Public Internet access / Mailing Lists <FONT face=Arial
size=2>--------------------------------------------------------------------
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 <FONT face=Arial
size=2>also send the HELP command for other information (like
subscribing). -- <FONT
face=Arial size=2>Please see the official ORACLE-L FAQ: <A
href="http://www.orafaq.com" target=_blank>http://www.orafaq.com
- Author:
Kevin Lange INET:
kgel_at_ppoone.com
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051 <FONT face=Arial
size=2>San Diego, California --
Public Internet access / Mailing Lists <FONT face=Arial
size=2>--------------------------------------------------------------------
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 <FONT face=Arial
size=2>also send the HELP command for other information (like
subscribing).
Received on Mon Sep 24 2001 - 13:14:42 CDT