Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace creation and privileges

Re: tablespace creation and privileges

From: ayrobins <anthony_at_lumos.com>
Date: Thu, 04 Apr 2002 20:38:50 GMT
Message-ID: <uR2r8.2565$uH2.257399@dca1-nnrp2.news.algx.net>


thanx, that works!
-- anthony

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:a8icc1$u9b$1_at_lust.ihug.co.nz...
> Er, 'grant create tablespace to scott' usually does the trick.
>
> If you're ever stuck for a system privilege to grant, do a select * from
> system_privilege_map, and you'll see all of them that are available.
>
> Regards
> HJR
> --
> -----------------------------------------------
> Resources for Oracle : http://www.hjrdba.com
> ===============================
>
> "ayrobins" <anthony_at_lumos.com> wrote in message
> news:sl1r8.2537$uH2.256326_at_dca1-nnrp2.news.algx.net...
> > To all the dba's out there:
> >
> > How do i give table space creation privileges to
> > a normal user? I don't want to make him a DBA.
> >
> > thanx in advance.
> >
> >
>
>
Received on Thu Apr 04 2002 - 14:38:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US