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
|
|
|
|