subject:"Describe privilege on procedures packages"

RE: Describe privilege on procedures packages

2003-10-02 Thread Govindan K



Here we go:

http://www.geocities.com/dba_assist/scripts/show_procedure.html

HTH
GovindanK
-Original Message-





From: Jamadagni, Rajendra;Jamadagni, RajendraSent: 10/1/2003 1:25:33 PMTo: [EMAIL PROTECTED]Subject: RE: Describe privilege on procedures  packages

all_arguments

Raj

-Original Message-From: Govindan K [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 01, 2003 4:00 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Describe privilege on procedures  packages
Hi Pete

I see another restriction (as i choose to put it) with my code. In OUR setup, we use Packages
"Extensively" (front end being Java).We use RefCursors to send result set to Java.
When you describesuch a package ORACLE describes the structure
of theRef Cursor too which i could not get using user_arguments. If someone in the list has the time 
and inclination extend my code it would be useful. 

Here are some examples. (For Ref cursor as output)
PROCEDURE P_GET_AGENTArgument Name Type In/Out Default?-- --- -- I_AGENT_ID NUMBER INI_BUSINESS_NAME VARCHAR2 INI_TEL_NO!
;! ; VARCHAR2 INO_AGENT_DET REF CURSOR OUT RECORD OUT AGENT_ID NUMBER(6) OUT AGENT_NM!
nb! sp; VARCHAR2(50) OUT AGENT_PHONE_NO VARCHAR2(10) OUT ADR_SYS_NO NUMBER(10) OUT ADR_STREET VARCHAR2(50) OUT ADR_LINE_2 VARCHAR2(50)!
 OUT! nbsp; ADR_CITY VARCHAR2(30) OUT ADR_COUNTRY VARCHAR2(20) OUT ADR_ZIP VARCHAR2(5) OUT ADR_ZIP_PLUS VARCHAR2(4) OUT AG_REPORTING_PERIOD_FL VARCHAR2(1)!
nb! sp; OUT AG_PRS_CONTACT_NM VARCHAR2(75) OUTO_ERR_CODE NUMBER OUTO_ERR_MESG VARCHAR2 OUT

I am wondering where to get the details of O_AGENT_DETfrom? (which dba_view). 


HTH
GovindanK-Original Message-





From: Pete FinniganSent: 10/1/2003 4:02:29 AMTo: [EMAIL PROTECTED]Subject: Re: Describe privilege on procedures  packagesHi Govindan Good thought!!, I was going to suggest the same idea, just to go and get the description of the package / procedure / function from the dictionary and then grant access to the dictionary views needed. One slight flaw with your code though, you have selected from user_% views but the OP wanted to be able to let another user describe *his* procedures and packages, you would need to use dba_% views as if the "other" person had not been granted access to the OP's procedures then they wouldn't be in ALL_% for him or in user_% views. kind regards Pete In article <F001.00!
! [EMAIL PROTECTED]>, Govindan K <[EMAIL PROTECTED]>writes This was the closest i could get.  set pagesize 60; set linesize 180; column position noprint; column sequence noprint; break on object_type skip 1; break on package_name skip 1; break on object_name skip 1; column object_type format A15 wrap; column package_name format A30 wrap; column object_name format A30 wrap; column argument_name format A30 wrap; column in_out format A10 wrap; column data_type format A15 wrap; column default_value format A10 wrap; column type_name format A10 wrap; column type_subname format A10 wrap; select  b.object_type  ,a.package_name  ,a.object_name  ,a.argument_name  ,a.position  ,a.sequence  ,a.in_out  ,a.data_type  ,a.default_value  ,a!
.t! ype_name  ,a.type_subname  from user_arguments a  ,user_objects b  where a.position  0  and b.object_id = a.object_id  order by  b.object_type  ,a.package_name  ,a.object_name  , a.position /  Create a procedure which will dbms_output this and grant execute priviliges on it.  -Original Message-   From: Gary Jackson Sent: 9/30/2003 9:31:29 AM To: [EMAIL PROTECTED]  (Reposting from yesterday morning since I had no takers! :)  Hello, I wanted to give another user access to view my procedures  packages (just DESC capability), but it seems that the only way for him to be able to DESC them is for me to grant execute. Is this correct?? (I guess I have never had this situation before, it just seems surprising if the!
re i! s no way to grant a read-only privilege).  Thanks!  _  Author: Gary Jackson INET: [EMAIL PROTECTED]  .   ___ Get Your 10MB account for FREE at http://mail.arabia.com ! Access MILLIONS of JOBS NOW!  -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] _!
__Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

Re: Describe privilege on procedures packages

2003-10-01 Thread Pete Finnigan

Hi Govindan

Good thought!!, I was going to suggest the same idea, just to go and get
the description of the package / procedure / function from the
dictionary and then grant access to the dictionary views needed. 

One slight flaw with your code though, you have selected from user_%
views but the OP wanted to be able to let another user describe *his*
procedures and packages, you would need to use dba_% views as if the
other person had not been granted access to the OP's procedures then
they wouldn't be in ALL_% for him or in user_% views.

kind regards

Pete

In article [EMAIL PROTECTED], Govindan K
[EMAIL PROTECTED] writes
This was the closest i could get.
 
set pagesize 60;
set linesize 180;
column position noprint;
column sequence noprint;
break on object_type skip 1;
break on package_name skip 1;
break on object_name skip 1;
column object_type format A15 wrap;
column package_nameformat A30 wrap;
column object_name format A30 wrap;
column argument_name   format A30 wrap;
column in_out  format A10 wrap;
column data_type   format A15 wrap;
column default_value   format A10 wrap;
column type_name   format A10 wrap;
column type_subnameformat A10 wrap;
select 
  b.object_type
 ,a.package_name
 ,a.object_name
 ,a.argument_name
 ,a.position
 ,a.sequence
 ,a.in_out
 ,a.data_type
 ,a.default_value
 ,a.type_name
 ,a.type_subname
 from user_arguments a
,user_objects b
where  a.position  0
and b.object_id = a.object_id
order by
 b.object_type
,a.package_name
,a.object_name
, a.position
/
 
Create a procedure which will dbms_output this and grant execute
priviliges on it.

-Original Message-

From: Gary Jackson
Sent: 9/30/2003 9:31:29 AM
To: [EMAIL PROTECTED]

(Reposting from yesterday morning since I had no takers! :) 

Hello, 
I wanted to give another user access to view my procedures  packages
(just 
DESC capability), but it seems that the only way for him to be able to
DESC 
them is for me to grant execute. Is this correct?? (I guess I have never
had this situation before, it just seems surprising if there is no way
to 
grant a read-only privilege). 

Thanks! 

_ 

Author: Gary Jackson 
INET: [EMAIL PROTECTED] 

. 
   

___
Get Your 10MB account for FREE at http://mail.arabia.com !
Access MILLIONS of JOBS NOW!
http://ads.arabia.com/?SHT=text_email_english 

-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: Describe privilege on procedures packages

2003-10-01 Thread Tanel Poder

Hi!

But if this procedure runs in definer rights under schema where the objects
exist, then it should be possible?

Tanel.

- Original Message - 
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 1:59 PM


 Hi Govindan

 Good thought!!, I was going to suggest the same idea, just to go and get
 the description of the package / procedure / function from the
 dictionary and then grant access to the dictionary views needed.

 One slight flaw with your code though, you have selected from user_%
 views but the OP wanted to be able to let another user describe *his*
 procedures and packages, you would need to use dba_% views as if the
 other person had not been granted access to the OP's procedures then
 they wouldn't be in ALL_% for him or in user_% views.

 kind regards

 Pete

 In article [EMAIL PROTECTED], Govindan K
 [EMAIL PROTECTED] writes
 This was the closest i could get.
 
 set pagesize 60;
 set linesize 180;
 column position noprint;
 column sequence noprint;
 break on object_type skip 1;
 break on package_name skip 1;
 break on object_name skip 1;
 column object_type format A15 wrap;
 column package_nameformat A30 wrap;
 column object_name format A30 wrap;
 column argument_name   format A30 wrap;
 column in_out  format A10 wrap;
 column data_type   format A15 wrap;
 column default_value   format A10 wrap;
 column type_name   format A10 wrap;
 column type_subnameformat A10 wrap;
 select
   b.object_type
  ,a.package_name
  ,a.object_name
  ,a.argument_name
  ,a.position
  ,a.sequence
  ,a.in_out
  ,a.data_type
  ,a.default_value
  ,a.type_name
  ,a.type_subname
  from user_arguments a
 ,user_objects b
 where  a.position  0
 and b.object_id = a.object_id
 order by
  b.object_type
 ,a.package_name
 ,a.object_name
 , a.position
 /
 
 Create a procedure which will dbms_output this and grant execute
 priviliges on it.
 
 -Original Message-
 
 From: Gary Jackson
 Sent: 9/30/2003 9:31:29 AM
 To: [EMAIL PROTECTED]
 
 (Reposting from yesterday morning since I had no takers! :)
 
 Hello,
 I wanted to give another user access to view my procedures  packages
 (just
 DESC capability), but it seems that the only way for him to be able to
 DESC
 them is for me to grant execute. Is this correct?? (I guess I have never
 had this situation before, it just seems surprising if there is no way
 to
 grant a read-only privilege).
 
 Thanks!
 
 _
 
 Author: Gary Jackson
 INET: [EMAIL PROTECTED]
 
 .
 
 
 ___
 Get Your 10MB account for FREE at http://mail.arabia.com !
 Access MILLIONS of JOBS NOW!
 http://ads.arabia.com/?SHT=text_email_english

 -- 
 Pete Finnigan
 email:[EMAIL PROTECTED]
 Web site: http://www.petefinnigan.com - Oracle security audit specialists
 Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Pete Finnigan
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (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.net
-- 
Author: Tanel Poder
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: Describe privilege on procedures packages

2003-10-01 Thread Govindan K



Hi Pete

I see another restriction (as i choose to put it) with my code. In OUR setup, we use Packages
"Extensively" (front end being Java).We use RefCursors to send result set to Java.
When you describesuch a package ORACLE describes the structure
of theRef Cursor too which i could not get using user_arguments. If someone in the list has the time 
and inclination extend my code it would be useful. 

Here are some examples. (For Ref cursor as output)
PROCEDURE P_GET_AGENTArgument Name Type In/Out Default?-- --- -- I_AGENT_ID NUMBER INI_BUSINESS_NAME VARCHAR2 INI_TEL_NO!
; VARCHAR2 INO_AGENT_DET REF CURSOR OUT RECORD OUT AGENT_ID NUMBER(6) OUT AGENT_NM!
sp; VARCHAR2(50) OUT AGENT_PHONE_NO VARCHAR2(10) OUT ADR_SYS_NO NUMBER(10) OUT ADR_STREET VARCHAR2(50) OUT ADR_LINE_2 VARCHAR2(50) OUT&!
nbsp; ADR_CITY VARCHAR2(30) OUT ADR_COUNTRY VARCHAR2(20) OUT ADR_ZIP VARCHAR2(5) OUT ADR_ZIP_PLUS VARCHAR2(4) OUT AG_REPORTING_PERIOD_FL VARCHAR2(1)!
sp; OUT AG_PRS_CONTACT_NM VARCHAR2(75) OUTO_ERR_CODE NUMBER OUTO_ERR_MESG VARCHAR2 OUT

I am wondering where to get the details of O_AGENT_DETfrom? (which dba_view). 


HTH
GovindanK-Original Message-





From: Pete FinniganSent: 10/1/2003 4:02:29 AMTo: [EMAIL PROTECTED]Subject: Re: Describe privilege on procedures  packagesHi Govindan Good thought!!, I was going to suggest the same idea, just to go and get the description of the package / procedure / function from the dictionary and then grant access to the dictionary views needed. One slight flaw with your code though, you have selected from user_% views but the OP wanted to be able to let another user describe *his* procedures and packages, you would need to use dba_% views as if the "other" person had not been granted access to the OP's procedures then they wouldn't be in ALL_% for him or in user_% views. kind regards Pete In article , Govindan K <[EMAIL PROTECTED]>writes This was the closest i could get.  set pagesize 60; set linesize 180; column position noprint; column sequence noprint; break on object_type skip 1; break on package_name skip 1; break on object_name skip 1; column object_type format A15 wrap; column package_name format A30 wrap; column object_name format A30 wrap; column argument_name format A30 wrap; column in_out format A10 wrap; column data_type format A15 wrap; column default_value format A10 wrap; column type_name format A10 wrap; column type_subname format A10 wrap; select  b.object_type  ,a.package_name  ,a.object_name  ,a.argument_name  ,a.position  ,a.sequence  ,a.in_out  ,a.data_type  ,a.default_value  ,a.t!
ype_name  ,a.type_subname  from user_arguments a  ,user_objects b  where a.position  0  and b.object_id = a.object_id  order by  b.object_type  ,a.package_name  ,a.object_name  , a.position /  Create a procedure which will dbms_output this and grant execute priviliges on it.  -Original Message-   From: Gary Jackson Sent: 9/30/2003 9:31:29 AM To: [EMAIL PROTECTED]  (Reposting from yesterday morning since I had no takers! :)  Hello, I wanted to give another user access to view my procedures  packages (just DESC capability), but it seems that the only way for him to be able to DESC them is for me to grant execute. Is this correct?? (I guess I have never had this situation before, it just seems surprising if there i!
s no way to grant a read-only privilege).  Thanks!  _  Author: Gary Jackson INET: [EMAIL PROTECTED]  .   ___ Get Your 10MB account for FREE at http://mail.arabia.com ! Access MILLIONS of JOBS NOW!  -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] 

___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

RE: Describe privilege on procedures packages

2003-10-01 Thread Jamadagni, Rajendra




all_arguments

Raj

  -Original Message-From: Govindan K 
  [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 01, 2003 
  4:00 PMTo: Multiple recipients of list ORACLE-LSubject: 
  Re: Describe privilege on procedures  packages
  Hi Pete
  
  I see another restriction (as i choose to put it) with my code. In OUR 
  setup, we use Packages
  "Extensively" (front end being Java).We use RefCursors to 
  send result set to Java.
  When you describesuch a package ORACLE describes the 
structure
  of theRef Cursor too which i could not get using 
  user_arguments. If someone in the list has the time 
  and inclination extend my code it would be useful. 
  
  Here are some examples. (For Ref cursor as output)
  PROCEDURE P_GET_AGENTArgument 
  Name 
  Type 
  In/Out Default?-- 
  --- -- 
  I_AGENT_ID 
  NUMBER 
  INI_BUSINESS_NAME 
  VARCHAR2 
  INI_TEL_NO! 
  ; 
  VARCHAR2 
  INO_AGENT_DET 
  REF 
  CURSOR 
  OUT 
  RECORD 
  OUT 
  AGENT_ID 
  NUMBER(6) 
  OUT 
  AGENT_NMnb! 
  sp; 
  VARCHAR2(50) 
  OUT 
  AGENT_PHONE_NO 
  VARCHAR2(10) 
  OUT 
  ADR_SYS_NO 
  NUMBER(10) 
  OUT 
  ADR_STREET 
  VARCHAR2(50) 
  OUT 
  ADR_LINE_2 
  VARCHAR2(50) 
  OUT! nbsp; 
  ADR_CITY 
  VARCHAR2(30) 
  OUT 
  ADR_COUNTRY 
  VARCHAR2(20) 
  OUT 
  ADR_ZIP 
  VARCHAR2(5) 
  OUT 
  ADR_ZIP_PLUS 
  VARCHAR2(4) 
  OUT AG_REPORTING_PERIOD_FL 
  VARCHAR2(1)nb! 
  sp; 
  OUT 
  AG_PRS_CONTACT_NM 
  VARCHAR2(75) 
  OUTO_ERR_CODE 
  NUMBER 
  OUTO_ERR_MESG 
  VARCHAR2 
  OUT
  
  I am wondering where to get the details of O_AGENT_DETfrom? (which 
  dba_view). 
  
  
  HTH
  GovindanK-Original Message-
  


  
  
  From: Pete 
FinniganSent: 10/1/2003 4:02:29 AMTo: 
[EMAIL PROTECTED]Subject: Re: Describe privilege on procedures 
 packagesHi Govindan 
Good thought!!, I was going to suggest the same idea, just to go 
and get the description of the package / procedure / function from 
the dictionary and then grant access to the dictionary views needed. 
One slight flaw with your code though, you have selected from 
user_% views but the OP wanted to be able to let another user 
describe *his* procedures and packages, you would need to use dba_% 
views as if the "other" person had not been granted access to the 
OP's procedures then they wouldn't be in ALL_% for him or in user_% 
views. kind regards Pete In article <F001.00! 
[EMAIL PROTECTED]>, Govindan K 
<[EMAIL PROTECTED]>writes This was the closest i could 
get.  set pagesize 60; set linesize 180; 
column position noprint; column sequence noprint; 
break on object_type skip 1; break on package_name skip 
1; break on object_name skip 1; column object_type 
format A15 wrap; column package_name format A30 wrap; 
column object_name format A30 wrap; column argument_name 
format A30 wrap; column in_out format A10 wrap; column 
data_type format A15 wrap; column default_value format A10 wrap; 
column type_name format A10 wrap; column type_subname 
format A10 wrap; select  b.object_type  
,a.package_name  ,a.object_name  ,a.argument_name 
 ,a.position  ,a.sequence  ,a.in_out  
,a.data_type  ,a.default_value  ,a.t! ype_name  
,a.type_subname  from user_arguments a  ,user_objects b 
 where a.position  0  and b.object_id = a.object_id 
 order by  b.object_type  ,a.package_name 
 ,a.object_name  , a.position /  
Create a procedure which will dbms_output this and grant execute 
priviliges on it.  -Original 
Message-   From: Gary Jackson Sent: 
9/30/2003 9:31:29 AM To: [EMAIL PROTECTED]  
(Reposting from yesterday morning since I had no takers! :) 
 Hello, I wanted to give another user access to 
view my procedures  packages (just DESC 
capability), but it seems that the only way for him to be able to 
DESC them is for me to grant execute. Is this correct?? 
(I guess I have never had this situation before, it just seems 
surprising if there i! s no way to grant a read-only 
privilege).  Thanks!  
_ 
 Author: Gary Jackson INET: 
[EMAIL PROTECTED]  .   
___ 
Get Your 10MB account for FREE at http://mail.arabia.com ! 
Access MILLIONS of JOBS NOW!  -- Pete 
Finnigan email:[EMAIL PROTECTED] Web site: 
http://www.petefinnigan.com - Oracle security audit specialists 
Book:Oracle security step-by-step Guide - see http://store.sans.org 
for details. -- Please see the official ORACLE-L FAQ: 
http://www.orafaq.net -- Author: Pet

Re: Describe privilege on procedures packages

2003-10-01 Thread Pete Finnigan

Hi Tanel,

I re-read Govindans post ( slowly this time ) and he does suggest
creating a procedure with this SQL and granting execute privileges on it
to the user, so yes it should work, I stand corrected!

kind regards

Pete

In article [EMAIL PROTECTED], Tanel Poder
[EMAIL PROTECTED] writes
Hi!

But if this procedure runs in definer rights under schema where the objects
exist, then it should be possible?

Tanel.

-- 
Pete Finnigan
email:[EMAIL PROTECTED]
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Finnigan
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Describe privilege on procedures packages

2003-09-30 Thread Gary Jackson

(Reposting from yesterday morning since I had no takers! :)

Hello,
I wanted to give another user access to view my procedures  packages (just 
DESC capability), but it seems that the only way for him to be able to DESC 
them is for me to grant execute.  Is this correct?? (I guess I have never 
had this situation before, it just seems surprising if there is no way to 
grant a read-only privilege).

Thanks!

_
Get MSN 8 Dial-up Internet Service FREE for one month.  Limited time offer-- 
sign up now!   http://join.msn.com/?page=dept/dialup

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary Jackson
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: Describe privilege on procedures packages

2003-09-30 Thread Rothouse, Michael

This link to AskTom may help.

http://tinyurl.com/p7o1


-Original Message-
Sent: Tuesday, September 30, 2003 12:29 PM
To: Multiple recipients of list ORACLE-L


(Reposting from yesterday morning since I had no takers! :)

Hello,
I wanted to give another user access to view my procedures  packages
(just 
DESC capability), but it seems that the only way for him to be able to
DESC 
them is for me to grant execute.  Is this correct?? (I guess I have
never 
had this situation before, it just seems surprising if there is no way
to 
grant a read-only privilege).

Thanks!

_
Get MSN 8 Dial-up Internet Service FREE for one month.  Limited time
offer-- 
sign up now!   http://join.msn.com/?page=dept/dialup

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Gary Jackson
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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.net
-- 
Author: Rothouse, Michael
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: Describe privilege on procedures packages

2003-09-30 Thread Paul Baumgartel

Yes, that's correct.  

Since the only privilege available on a code object is execute,  it
doesn't make much sense to allow a user to DESCRIBE the call interface
if the user cannot run it.  


--- Gary Jackson [EMAIL PROTECTED] wrote:
 (Reposting from yesterday morning since I had no takers! :)
 
 Hello,
 I wanted to give another user access to view my procedures  packages
 (just 
 DESC capability), but it seems that the only way for him to be able
 to DESC 
 them is for me to grant execute.  Is this correct?? (I guess I have
 never 
 had this situation before, it just seems surprising if there is no
 way to 
 grant a read-only privilege).
 
 Thanks!
 
 _
 Get MSN 8 Dial-up Internet Service FREE for one month.  Limited time
 offer-- 
 sign up now!   http://join.msn.com/?page=dept/dialup
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Gary Jackson
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (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!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Paul Baumgartel
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Re: Describe privilege on procedures packages

2003-09-30 Thread Govindan K




This was the closest i could get.

set pagesize 60;set linesize 180;column position noprint;column sequence noprint;break on object_type skip 1;break on package_name skip 1;break on object_name skip 1;column object_type format A15 wrap;column package_name format A30 wrap;column object_name format A30 wrap;column argument_name format A30 wrap;column in_out format A10 wrap;column data_type format A15 wrap;column default_value format A10 wrap;column type_name format A10 wrap;column type_subname format A10 wrap;select  b.object_type!
; ,a.package_name ,a.object_name ,a.argument_name ,a.position ,a.sequence ,a.in_out ,a.data_type ,a.default_value ,a.type_name!
; ,a.ty!
pe_subname from user_arguments a ,user_objects b where a.position  0 and b.object_id = a.object_id order by b.object_type ,a.package_name ,a.object_name , a.position/

Create a procedure which will dbms_output this and grant execute priviliges on it.-Original Message-





From: Gary JacksonSent: 9/30/2003 9:31:29 AMTo: [EMAIL PROTECTED]Subject: Re: Describe privilege on procedures  packages(Reposting from yesterday morning since I had no takers! :) Hello, I wanted to give another user access to view my procedures  packages (just DESC capability), but it seems that the only way for him to be able to DESC them is for me to grant execute. Is this correct?? (I guess I have never had this situation before, it just seems surprising if there is no way to grant a read-only privilege). Thanks! _ Author: Gary Jackson INET: [EMAIL PROTECTED] . 

___Get Your 10MB account for FREE at http://mail.arabia.com !Access MILLIONS of JOBS NOW!

Describe privilege on procedures packages

2003-09-29 Thread Gary Jackson

Hello,
 I wanted to give another user access to view my procedures  packages 
(just DESC capability), but it seems that the only way for him to be able to 
DESC them is for me to grant execute.  Is this correct?? (I guess I have 
never had this situation before, it just seems surprising if there is no way 
to grant a read-only privilege).

Thanks!
-Fred S.
_
Share your photos without swamping your Inbox.  Get Hotmail Extra Storage 
today! http://join.msn.com/?PAGE=features/es

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gary Jackson
 INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

RE: Describe privilege on procedures packages

Re: Describe privilege on procedures packages

Re: Describe privilege on procedures packages

Re: Describe privilege on procedures packages

RE: Describe privilege on procedures packages

Re: Describe privilege on procedures packages

Describe privilege on procedures packages

RE: Describe privilege on procedures packages

Re: Describe privilege on procedures packages

Re: Describe privilege on procedures packages

Describe privilege on procedures packages

11 matches

Site Navigation

Mail list logo

Footer information