Hi Ankit,

Just check the EXECUTE PROCEDURE privilege for system from
dba_tab_privs.

Hope this helps.

Rahul Dutta


-----Original Message-----
From: Sood Ankit (GE Consumer Finance consultant)
[mailto:oracledba-ezmlmshield-x2086189.[Email address protected]
Sent: Tuesday, May 31, 2005 1:07 PM
To: LazyDBA Discussion
Subject: analyzed schema

Dear all,
I am using the Oracle procedure to analyze the schema.When I am maually
running the procedure it is running fine from the system user.
The same procedure running through Oracle jobs giving me error as
insufficient privileage.The same procedure is running fine from Oracle
jobs as sys user.
Please provide the input.



Regards
Ankit Sood
GE Consumer Finance
Japan
Phone: 042-330-8734
Mobile No: 09098429482




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page