Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tablespace creation and privileges
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