Re: indexes in non-system tablespaces

>From relay-wo!dtix.dt.navy.mil!darwin.sura.net!zaphod.mps.ohio-state.edu!hobbes.physics.uiowa.edu!news.iastate.edu!news Mon Mar 29 16:26:31 EST 1993
 

>Oracle, tell me it isn't true:
 

> ANY USER CAN CREATE AN INDEX IN ANY TABLESPACE.
 
>Your default tablespace concept is excellent, the ability to give users
>RESOURCE only on specific tablespaces is great, but what about indexes???
>Aren't indexes resources? How can you be so d... stupid???
 

>(timidly, calmly: am I missing something?)
 

>Is this addressed in Ver. 7 ?? Since the default tablespace (for other
>than create tables ...) is SYSTEM, how does one keep users out of the
>SYSTEM tablespace???
 

>If this is a repeat complaint/question, I apologize for wasting the
>bandwidth. We are getting ready to open up an ULTRIX-based client/server
>operation for university staff and students and I just found this out.
 

>I'M MAD AS HELL AT ORACLE, TOO. (yes, we also found the install scripts
>inept, were even instructed by support to modify them--no's for absent
>products ignored; had to comment out the queries for absent products).
 

>Marvin Beck Iowa State University

      Users can create indexes *only* in tablespaces where they have been granted resources (Version 6). If your users seem to be doing otherwise, check what resources you've actually given them. If you ever did "GRANT RESOURCE TO USER" without specifying tablespace you must specifically "REVOKE RESOURCE FROM USER". This will have no effect on resources granted on specific tablespaces - Oracle keeps the information in two different places. Somewhat comfusing, but that's the way it works. Received on Mon Mar 29 1993 - 23:34:55 CEST