Home » RDBMS Server » Security » insufficient privilege to access object SYS.DBA_SEGMENTS
insufficient privilege to access object SYS.DBA_SEGMENTS [message #39590] Wed, 24 July 2002 21:11 Go to next message
Gautam
Messages: 24
Registered: February 2002
Junior Member
Hi,

Ther are two invalid procedures which are not able to compile. Then I tried to compile them by giving the sql statement"
" alter PROCEDURE OM.REMOVEPARTITION compile ;"
It have prompted with a warning message:
"Warning: Procedure altered with compilation errors."
After this, I have given a statemetn "show errors" to know the problem......!
It has given this information..can anyone help me in solving this insufficient privileges problem...VERY URGENT..!
SQL> show errors
Errors for PROCEDURE OM.REMOVEPARTITION:
29/3 PL/SQL: SQL Statement ignored
30/8 PLS-00904: insufficient privilege to access object SYS.DBA_SEGMENTS
40/5 PL/SQL: Statement ignored
40/19 PLS-00364: loop index variable 'REC_SEG' use is invalid
45/5 PL/SQL: Statement ignored
45/8 PLS-00364: loop index variable 'REC_SEG' use is invalid
114/5 PL/SQL: SQL Statement ignored
115/10 PLS-00904: insufficient privilege to access object

SYS.DBA_CONSTRAINTS

130/5 PL/SQL: Statement ignored
130/31 PLS-00364: loop index variable 'REC_REF_FK' use is invalid
167/3 PL/SQL: SQL Statement ignored
168/8 PLS-00904: insufficient privilege to access object

SYS.DBA_INDEXES

174/3 PL/SQL: SQL Statement ignored
175/8 PLS-00904: insufficient privilege to access object

SYS.DBA_IND_COLUMNS

191/5 PL/SQL: Statement ignored
191/9 PLS-00364: loop index variable 'REC_IND' use is invalid
195/5 PL/SQL: Statement ignored
195/31 PLS-00364: loop index variable 'REC_IND' use is invalid
198/5 PL/SQL: Statement ignored
198/30 PLS-00364: loop index variable 'REC_IND' use is invalid

Thanks
Gautam
Re: insufficient privilege to access object SYS.DBA_SEGMENTS [message #39598 is a reply to message #39590] Thu, 25 July 2002 09:03 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The user OM will need a direct grant (not a grant through a role) from SYS on all of those views in order to be able to compile that procedure.
Previous Topic: Audit
Next Topic: Security and Stored procedures/anonymous PL/SQL blocks
Goto Forum:
  


Current Time: Thu Mar 28 10:36:19 CDT 2024