OraFAQ Forum: Server Utilities » Create index with a new user?

Home » RDBMS Server » Server Utilities » Create index with a new user?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create index with a new user? [message #69839]

Wed, 13 March 2002 05:40

Sven
Messages: 10
Registered: July 2001

Junior Member

Sorry if thi quizz is stupid, but today I have total brain damage...

If I create a new user that have a different default tablespace, and then create all indexes with that user, can all the other users use the indexes?
I.e. I want to separate the table and the index but also separate the users that created them.

Regards,
Sven

Report message to a moderator

Re: Create index with a new user? [message #69840 is a reply to message #69839]

Wed, 13 March 2002 07:10

Grant
Messages: 578
Registered: January 2002

Senior Member

If the user has access to the associated table they will have access to the index.

Report message to a moderator

Re: Create index with a new user? [message #69850 is a reply to message #69839]

Wed, 13 March 2002 11:18

Mike
Messages: 417
Registered: September 1998

Senior Member

why would you create all indexes with a different user?

What are you going to do with the primary and unique key indexes?

Report message to a moderator

Re: Create index with a new user? [message #69859 is a reply to message #69850]

Thu, 14 March 2002 03:37

Sven
Messages: 10
Registered: July 2001

Junior Member

I want to get rid of changing the default tablespace for the user that owns the tables when creating indexes in a separate tablespace.

Sven

Report message to a moderator

Previous Topic:	SQLLDR and blank interpreted as NULL?
Next Topic:	Re: sql*loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 01:41:06 CDT 2024