Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Please help! ORA-01031: insufficient privileges

Re: Please help! ORA-01031: insufficient privileges

From: Lubomir Petrov <lpetrov_at_yahoo.com>
Date: 10 Dec 2001 20:12:40 -0800
Message-ID: <75805ad9.0112102012.4c44baf8@posting.google.com> 





Hi,



Think for a while:


    
  
  1.   If you USE ALTER ANY INDEX privilege and USE roles you can
rebuild the index online.
  
  2.   If you USE ALTER ANY INDEX privilege and DO NOT USE roles you
CAN'T rebuild the index online.






Therefore, you need one of the privileges that is granted to this
roles. Where you can find them? In the dictionary, of course. Check
ROLE_SYS_PRIVS and ROLE_TAB_PRIVS to see which privileges are granted
to which roles. Now it is easy to find the answer...




Regards


Lyubomir Petrov
Received on Mon Dec 10 2001 - 22:12:40 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US