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
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