Re: New tablespace, new user with full access to tablespace?

danny de bie <danny_at_larix.com> wrote:

>Hi,
>
>I'd like to create a new tablespace and a single new user. I want
>to limit the new user's access to the single new tablespace, and I
>want him to be able to do anything in this tablespace.
>
>This may be a FAQ, or just a TSQ (Terminally Stupid Question), but
>I can not find any doc on how to accomplish this.
>
>Any suggestions? Many thanks in advance!
>
>
>- Danny

Just create the tablespace, the user, and grant privs to the user.

create tablespace joes_ts datafile 'joes_file' size 10m; create user joe identified by joes_pswd
  default tablespace joes_ts
  quota unlimited on joes_ts;
grant create table to joe;

--
Chuck Hamilton
chuckh_at_dvol.com

Never share a foxhole with anyone braver than yourself!