RE: quick pl/sql question

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 22 Apr 2004 08:54:03 -0400
Message-ID: <001101c42868$e3e96490$0704a8c0@development.perceptron.com>

Does it work if executed by the owner of the package?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Sharples Sent: Thursday, April 22, 2004 4:49 AM
To: oracle-l_at_freelists.org
Subject: FW: quick pl/sql question

OK,

Doesn't quite work, the owner of the package is not the same person who is executing the package.

Anyone know how to get it so any user can run it. Again it was failing on the dbms_resource_manager part - That user does have execute permission on those procedures.

Should it work?

From: David Sharples
Sent: 21 April 2004 20:37
To: oracle-l_at_freelists.org
Subject: RE: quick pl/sql question

Worked like a dream, thanks!

From: oracle-l-bounce_at_freelists.org on behalf of Freeman, Donald Sent: Wed 21/04/2004 18:17
To: oracle-l_at_freelists.org
Subject: RE: quick pl/sql question

It's not the execute you are having problems with. The access you have = to the underlying objects is granted to you through a role. I don't know =
if I'm describing this exactly right but roles aren't referred within = PL/SQL so you have to have direct privs on the objects. =20

Or,You can add "AUTHID CURRENT_USER" like so,

CREATE OR REPLACE PROCEDUREdave.test (whatever varchar2) AUTHID CURRENT_USER
AS.....

That should do the trick...

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of David Sharples
> Sent: Wednesday, April 21, 2004 12:17 PM
> To: oracle-l_at_freelists.org
> Subject: RE: quick pl/sql question

>=20
>=20

> Thanks but.

>=20

> SQL> connect / as sysdba
> Connected.
> SQL> grant execute on dbms_resource_manager to cerebrus;

>=20

> Grant succeeded.

>=20

> SQL> grant execute on dbms_resource_manager_privs to cerebrus;

>=20

> Grant succeeded

>=20

> SQL> connect cerebrus/cerebrus
> Connected.

>=20

> SQL> exec dave_test('ds');
> BEGIN dave_test('ds'); END;

>=20

> *
> ERROR at line 1:
> ORA-00942: table or view does not exist
> ORA-06512: at "SYS.DBMS_RMIN", line 56
> ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER_PRIVS", line 99
> ORA-06512: at "CEREBRUS.DAVE_TEST", line 3
> ORA-06512: at line 1

>=20
>
>=20
----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Apr 22 2004 - 07:50:32 CDT