INDEX Use How?

We want to establish two tablespaces(one for tables and the other for indices). If we give users privileges to create an index via "create index" or create a table using a primary key, how can we guarantee that the indices reside in the established index tablespace by default? In other words how do we make sure all indices are where we want them to be.

Karen Byrd
Univ of Pa, School of Med.
Computing and Info Tech

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet