Re: CREATE TABLE not acting the way I think it should
From: L. Carl Pedersen <carl.pedersen_at_dartmouth.edu>
Date: 20 Jul 92 16:34:07 GMT
Message-ID: <carl.pedersen-200792123110_at_kip-sn-93.dartmouth.edu>
Date: 20 Jul 92 16:34:07 GMT
Message-ID: <carl.pedersen-200792123110_at_kip-sn-93.dartmouth.edu>
In article <1992Jul13.175108.24837_at_fang.att.com>, ebd_at_fang.att.com (Elliot
B Dierksen) wrote:
>
> I am using Oracle 6.0.33.1.2 on SVR4 on a 386 PC. What I want to is to create
> a table specifying 'user.tablename'. I have tried this as SYS & SYSTEM and
> other DBA accounts and it tells me 'no resource permission'. Can you create a
> table to be owned by another user, or am I missing something.
The user for whom you are creating the table needs to have resource privilege on the tablespace where the table is going to end up. You can grant resource, create the table, then revoke resource, if you want (I think). Received on Mon Jul 20 1992 - 18:34:07 CEST