indexes in non-system tablespaces

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 Received on Mon Mar 29 1993 - 19:56:33 CEST