OraFAQ Forum: Security » Grant EXECUTE ANY PROCEDURE to the user

Home » RDBMS Server » Security » Grant EXECUTE ANY PROCEDURE to the user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grant EXECUTE ANY PROCEDURE to the user [message #218486]

Thu, 08 February 2007 06:52

amkotz
Messages: 72
Registered: May 2005
Location: Bangalore

Member

Hello All,

I have user TEST which has this privileges as shouwn 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 possiblity to acheive this.?

Regds,
Amkotz

Report message to a moderator