Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
• ORA 12540: TNS:internal limit restriction exceeded
• ORA 12838 please : Is possible to append two times to the same table befo
• ORA 12838 please : Is possible to append two times to the same table before
• ora 04031
• ora 12500 on windows
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ora 12500 on windows
• ORA 01650, one idea
• ORA 01650
• ORA 4030
• ORA 12838 please : Is possible to append two times to thesametable before do
• ORA 12838 please : Is possible to append two times to thesame table before d
• ORA 01536
• ORA 03113 end of file on communication channel
• ORA 32004: obsolete and/or deprecated parameter(s) specified
• ORA 00600:
• ORA 00020: maximum number of processes (%s) exceeded
• ORA 01925: maximum of 30 enabled roles exceeded
• ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 01650, one idea
• ora 12500 on windows
• ora 12500 on windows
• ora 12500 on windows
• ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650, one idea
• ORA 01650
• ORA 01650
• ORA 01031
• ORA 4030
• ORA 4030
• ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
• ORA 01722 invalid number
 
All_Source Question

All_Source Question

2007-10-01       - By sol beach

 Back
Just have them check the code out of your Source Code Control system.

On 10/1/07, Sam Bootsma <sbootsma@(protected)> wrote:
>
>  We would like our developers to see source code for all objects in
> selected schemas in our production database.  I believe I have read that
> granting execute privilege on a stored procedure will also make that stored
> procedure visible in the all_source view, but we do not want to give our
> developers execute privileges in the production environment.
>
>
>
> Is there a way to enable developers to view all source code for selected
> schemas without providing additional privileges?  I'd like to avoid giving
> dba_source privileges.
>
>
>
> Thanks!
>
>
>
> *Sam Bootsma*
>
> *Oracle Database Administrator*
>
> *Information** Technology Services**
> George Brown College*
>
> *Phone: 416-415-5000 x4933**
> Fax: 416-415-4836**
> E-mail: **sbootsma@(protected)* <sbootsma@(protected)>
>
>
>

Just have them check the code out of your Source Code Control system.<br><br>
<div><span class="gmail_quote">On 10/1/07, <b class="gmail_sendername">Sam
Bootsma</b> &lt;<a href="mailto:sbootsma@(protected)">sbootsma@(protected)
.ca</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
">We would like our developers to see source code for all objects in selected
schemas in our production database.&nbsp; I believe I have read that granting
execute privilege on a stored procedure will also make that stored procedure
visible in the all_source view, but we do not want to give our developers
execute privileges in the production environment.
</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
">&nbsp;</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
">Is there a way to enable developers to view all source code for selected
schemas without providing additional privileges?&nbsp; I'd like to avoid giving
dba_source privileges.
</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
">&nbsp;</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
">Thanks!</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial
">&nbsp;</span></font></p>
<p><em><i><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"
>Sam Bootsma</span></font></i></em></p>
<p><em><i><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"
>Oracle Database Administrator</span></font></i></em></p>
<p><em><i><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"
>Information</span></font></i></em><em><i><font face="Times New Roman">
Technology Services</font></i></em><i><font face="Arial" size="2"><span style=
"FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
<br></span></font><em><i><font face="Times New Roman">George</font></i></em><em
><i><font face="Times New Roman"> Brown College</font></i></em></i></p>
<p><em><i><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"
>Phone: 416-415-5000 x4933</span></font></i></em><i><font face="Arial" size="2">
<span style="FONT-SIZE: 10pt; FONT-STYLE: italic; FONT-FAMILY: Arial">
<br></span></font><em><i><font face="Times New Roman">Fax: 416-415-4836</font><
/i></em></i><i><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT
-STYLE: italic; FONT-FAMILY: Arial"><br></span></font><em><i><font face="Times
New Roman">
E-mail: </font></i></em></i><a title="mailto:sbootsma@(protected)" onclick=
"return top.js.OpenExtLink(window,event,this)" href="mailto:sbootsma@(protected)
.ca" target="_blank"><em><i><font face="Times New Roman" color="black">
<span style="COLOR: windowtext; TEXT-DECORATION: none"><span title="mailto
:sbootsma@(protected)">sbootsma@(protected)</span></span></font></i></em><
/a></p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">&nbsp;<
/span></font></p></div></div></blockquote></div><br>