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

From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1996/04/10
Message-ID: <316c0578.1342641_at_news2.ios.com>#1/1


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!
Received on Wed Apr 10 1996 - 00:00:00 CEST

Original text of this message