Hi
It has worked. Giving ALTER USER privilege to this user has made it
possible to change its default tablespace without DBA rights. I was
wondering, if it could be possible to give some other privilege which
would allow a user to change only its default tablespace and not for
some other user. This privilege seems to allow the user to change
default tablespace for other users as well.
thanks
Praveen
DA Morgan wrote:
> impraveen_at_gmail.com wrote:
> > Hi
> > Thanks for the response guys... There is only one owner and we do not
> > want to give it DBA rights. Also, the separate tablespaces are for
> > performance gain, i.e. one set of tables in one tablespace and other
> > more performance hungry tables in other tablespace. One of the
> > tablespace would be default for our owner.
> > Also, Scripts are always run as owner.
> > -Praveen
>
> Read a good book on tuning. What you describe above makes no sense.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)
Received on Tue Oct 18 2005 - 23:52:44 CDT
