In article <36C88853.A5E80BD8_at_erols.com>, joe gulla <jgulla_at_erols.com>
writes
> If people start adding their own datafiles your backup strategy could
>get toasted. Do you really want to go that way.
> Joe
>
>Pat Minnis wrote:
>
>> Might need to connect such-and-such as sysdba?
>>
>> Adrian Harrison wrote in message <36a6c1b2.6816511_at_news.globalnet.co.uk>...
>> >Have a user with DBA rights but can't add a datafile to a tablespace! -
>> have to login as "System"
>> >user to do this!
>> >
>> >What rights do I have to assign so that they can do this themselves?
>> >
>> >Thanks
>> >
>> >A.H
>
To answer the original question they will need a quota on the tablespace
they are creating the table in as well as create table rights. These
may be contained with DBA role but granting resource will give an
unlimited quota on all tablespaces (including the SYSTEM tablespace!)
--
Diane
Received on Wed Feb 17 1999 - 13:58:03 CST
