Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why can't user with DBA rights add datafile to tablespace?
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
Received on Mon Feb 15 1999 - 14:49:23 CST