Re: New tablespace, new user with full access to tablespace?
From: Vijay Banda <vbanda_at_fldb1.fl.ford.com>
Date: 1996/04/15
Message-ID: <4ktjkq$43p_at_eccdb1.pms.ford.com>#1/1
Date: 1996/04/15
Message-ID: <4ktjkq$43p_at_eccdb1.pms.ford.com>#1/1
create your tablespace first using your create tablespace command eg:- create tablespace my_test
DATAFILE 'filename'
DEFAULT STORAGE 'storage_clause';
then Do your create user command like this
Create user dummy identified dummy
DEFAULT TABLESPACE my_test
quota unlimited;
for more info look for the syntax of create user commannd.. Received on Mon Apr 15 1996 - 00:00:00 CEST