Re: Default Tablespace Questions

I think you might have some misunderstanding of terms. It would be a good idea to stop now and read the Oracle Concepts manual which you can find on TechNet under documentation. The way the various pieces interact is something that will come up every day you use Oracle,so even if it costs you a week now you'll save a great deal of time in the long run by being familiar with Oracle's concepts.

Van

Seajay <seajaysNOseSPAM_at_hotmail.com.invalid> wrote in message news:097065ae.3322c88d_at_usw-ex0101-007.remarq.com...
> I have a user who has a default tablespace set, the user also
> has the 'unlimited tablespace' system privilege.
>
> However, when I try to use the DBA Studio in Oracle 8i to
> change 'Object Privileges' to give access to the tablespace I
> can't make changes. (Insufficient privilige)
>
> We have ONLY just started trying to use Oracle so I'm very new
> at it. What I want to do is:
>
> Create a new user who has full access to a particular tablespace
> but no access to any others (unless its necessary for something
> fundamental).
>
> Also, if a default tablespace is set, do I HAVE to still include
> the tablespace name in SQL queries, or will it assume the
> tablespace if it is not included?
>
> Thanks,
>
> Seajay.
>
> email: seajays_at_hotmail.com
> web: www.mufasa.freeserve.co.uk
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Tue Jun 27 2000 - 00:00:00 CDT