Re: User setup

Hi John,

        Your posting cites two different issues;

1. Default tablespace for a user
2. Accessing tables owned by another user.

If your concern is which tablespace will be used just create your user as follows:

	CREATE USER joe IDENTIFIED BY password
	DEFAULT TABLESPACE accounting
	TEMPORARY TABLESPACE temp_space
	QUOTA UNLIMITED ON accounting

This will create user joe and all of joe's tables will be stored in the tablspace called accounting.

If you mean "How can a user access another's tables without explicitly specifying the owner in the form 'owner.table_name'" you can achieve this through the use of public synonyms.

regards

Jerry

John Bester wrote:
>
> I want to create a user that must default to the table space of another
> user. eg. I log in as ME and want to select data from a table created by
> SOMEBODYELSE and I do not want to type SELECT * FROM SOMEBODYELSE.ANYTABLE -
> I want to be able to do it without specifying SOMBODYELSE. Can I do this,
> and how do I set it up?
>
> --
> John Bester
> johnb_at_iconnect.co.za

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group