Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grant EXECUTE ANY PROCEDURE to the user

amrish kothariFeb 8 2007 — edited Feb 14 2007
Hello All,

I have user TEST which has this privileges as shown below.

TEST@ORA> select * from session_privs;

PRIVILEGE
----------------------------------------
CREATE SESSION
ALTER SESSION
CREATE TABLE
CREATE CLUSTER
CREATE SYNONYM
CREATE VIEW
CREATE SEQUENCE
CREATE DATABASE LINK
SELECT ANY DICTIONARY

I want to give the user EXECUTE ANY PROCEDURE Privilege.
I am not a DBA user and also i do not know the SYS/SYSTEM password.

Is there any possibility to achieve this.?


Regds,
Amkotz
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 14 2007
Added on Feb 8 2007
13 comments
1,054 views