FW: quick pl/sql question
- From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 22 Apr 2004 10:48:32 +0100
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@xxxxxxxxxxxxx
Subject: RE: quick pl/sql question
Worked like a dream, thanks!
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Freeman, Donald
Sent: Wed 21/04/2004 18:17
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of David Sharples
> Sent: Wednesday, April 21, 2004 12:17 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
