| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> AW: Privileges and PL/SQL code
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C349FF.9A569700
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
That's what I was afraid of 8-{ ... oh well.
Since we have several developer's working on local copies of the code =
in
schemas B, C, etc.,
I guess I have to grant privileges to all schemas.
=20
Thanks for the quick response.
Stefan
Stefan Jahnke=20
Consultant=20
BOV Aktiengesellschaft=20
Tel.: +49 201/45 13-289=20
mailto:stefan.jahnke_at_nospam.bov.de <mailto:stefan.jahnke_at_nospam.bov.de> =
=20
http://www.bov.de <http://www.bov.de/> =20
Abonnieren Sie unseren Newsletter: http://www.bov.de/enews
<http://www.bov.de/enews> =20
Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am
24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day
<http://www.bov.de/microsoft-day> oder mailto:andrea.palluck@bov.de
<mailto:andrea.palluck_at_bov.de> .
Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht =
unter
fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde =
bitten wir
um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die =
rechtliche
Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen
ausschliessen.
As you are probably aware, e-mails sent via the Internet can easily be
copied or manipulated by third parties. For this reason we would ask =
for
your understanding that, for your own protection and ours, we must =
decline
all legal responsibility for the validity of the statements and =
comments
given above.
-----Urspr=FCngliche Nachricht-----
Von: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]
Gesendet: Montag, 14. Juli 2003 14:49
An: Multiple recipients of list ORACLE-L
Betreff: RE: Privileges and PL/SQL code
If you don't want to do that, create your pl/sql code under schema A =
and
grant execute on those to B and C.=20
Sorry ... that's the only way to go ...=20
Raj=20
------------------------------------------------------------------------=
-----Original Message-----=20
From: Stefan Jahnke [ mailto:Stefan.Jahnke_at_bov.de
<mailto:Stefan.Jahnke_at_bov.de> ]=20
Sent: Monday, July 14, 2003 8:31 AM=20
To: Multiple recipients of list ORACLE-L=20
Subject: Privileges and PL/SQL code=20
Hi list=20
I was wondering if there is any way to get the following to work:=20
User A owns all tables, users B,C own PL/SQL code to access A's tables. =
To work with A's tables from user B and C, I would like to create a =
role to=20
contain all the object privileges and grant these to B and C.=20
Didn't use to work, since PL/SQL is not particularly interested in =
grants=20
received through roles.=20
But I don't really want to grant all privileges directly to B and C =
(and=20
many more users).=20
Is there a way in 9i that works better ? Any improvements I missed out = on ?=20
Thanks in advance,=20
Stefan=20
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net> =20
--=20
Author: Stefan Jahnke=20
INET: Stefan.Jahnke_at_bov.de=20
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com> =20
San Diego, California -- Mailing list and web hosting services=20
---------------------------------------------------------------------=20To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You may=20 also send the HELP command for other information (like subscribing).=20
=20
------_=_NextPart_001_01C349FF.9A569700
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>RE: Privileges and PL/SQL code</TITLE>
<META content=3D"MSHTML 5.50.4522.1800" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D796165811-14072003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>That's what I was afraid of 8-{ ... oh=20
well.</FONT></SPAN></DIV>
<DIV><SPAN class=3D796165811-14072003><FONT face=3DArial =
color=3D#0000ff size=3D2>Since=20
we have several developer's working on local copies of the code in =
schemas B, C,=20
etc.,</FONT></SPAN></DIV>
<DIV><SPAN class=3D796165811-14072003><FONT face=3DArial =
color=3D#0000ff size=3D2>I=20
guess I have to grant privileges to all schemas.</FONT></SPAN></DIV>
<DIV><SPAN class=3D796165811-14072003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D796165811-14072003><FONT face=3DArial =
color=3D#0000ff size=3D2>Thanks=20
for the quick response.</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D796165811-14072003>Stefan</SPAN></FONT></DIV>
<P><FONT face=3D"Century Gothic" size=3D2>Stefan Jahnke</FONT> =
<BR><FONT=20
face=3D"Century Gothic" size=3D2>Consultant</FONT> <BR><FONT = face=3D"Century Gothic"=20 size=3D2>BOV Aktiengesellschaft</FONT> <BR><FONT face=3D"Century =Gothic"=20
size=3D2>---------------------------------------------------------------= -----------------</FONT>=20
size=3D2>---------------------------------------------------------------=------</FONT>=20
 |
 |