| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Help! Security for Packages
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_01C023CD.5502C88C
Content-Type: text/plain;
charset="iso-8859-1"
Hi Ron,
The developer must have privileges (select, at least) on the table granted directly to the schema in which he wishes to write his package. Grants cannot be through a role.
If your intent is to hide the table from the developer, write a procedure in the schema owning the table, grant the developer execute on the procedure and do not grant him any privs on the base table.
Does that answer your question? Your question seemed kind of broad.
HTH
Lisa
Ft. Lauderdale, FL, USA
-----Original Message-----
From: Smith, Ron L. [mailto:rlsmith_at_kmg.com]
Sent: Wednesday, September 20, 2000 6:36 PM
To: Multiple recipients of list ORACLE-L
Subject: Help! Security for Packages
Can someone please tell me the minimum security needed for a developer to create a Package or Procedure in his own schema that reads one table from another schema on the same instance?
Ron Smith
Database Administration
rlsmith_at_kmg.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: rlsmith_at_kmg.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). ------_=_NextPart_001_01C023CD.5502C88C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printableReceived on Thu Sep 21 2000 - 08:10:36 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Help! Security for Packages</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hi Ron, </FONT>
</P>
<P><FONT SIZE=3D2>The developer must have privileges (select, at least) =
on the table granted directly to the schema in which he wishes to write = his package. Grants cannot be through a role. </FONT></P>
<P><FONT SIZE=3D2>If your intent is to hide the table from the =
developer, write a procedure in the schema owning the table, grant the = developer execute on the procedure and do not grant him any privs on = the base table. </FONT></P>
<P><FONT SIZE=3D2>Does that answer your question? Your question =
seemed kind of broad.</FONT>
</P>
<P><FONT SIZE=3D2>HTH</FONT>
<BR><FONT SIZE=3D2>Lisa</FONT>
<BR><FONT SIZE=3D2>Ft. Lauderdale, FL, USA</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Smith, Ron L. [<A =
HREF=3D"mailto:rlsmith_at_kmg.com">mailto:rlsmith_at_kmg.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, September 20, 2000 6:36 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Help! Security for Packages</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>Can someone please tell me the minimum security =
needed for a developer to</FONT>
<BR><FONT SIZE=3D2>create a Package or Procedure in his own schema that =
reads one table from</FONT>
<BR><FONT SIZE=3D2>another schema on the same instance?</FONT>
</P>
<P><FONT SIZE=3D2>Ron Smith</FONT>
<BR><FONT SIZE=3D2>Database Administration</FONT>
<BR><FONT SIZE=3D2>rlsmith_at_kmg.com</FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Smith, Ron L.</FONT>
<BR><FONT SIZE=3D2> INET: rlsmith_at_kmg.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
 |
 |