Path: news.easynews.com!easynews!feedwest.news.agis.net!aleron.net!sfo2-feed1.news.algx.net!allegiance!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!lust.ihug.co.nz!ihug.co.nz!not-for-mail From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server Subject: Re: tablespace creation and privileges Date: Fri, 5 Apr 2002 06:15:47 +1000 Organization: ihug ( New Zealand ) Lines: 24 Message-ID: References: NNTP-Posting-Host: p108-tnt8.syd.ihug.com.au X-Trace: lust.ihug.co.nz 1017951426 31019 203.173.147.108 (4 Apr 2002 20:17:06 GMT) X-Complaints-To: abuse@ihug.co.nz NNTP-Posting-Date: Thu, 4 Apr 2002 20:17:06 +0000 (UTC) X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Xref: easynews comp.databases.oracle.server:142079 X-Received-Date: Thu, 04 Apr 2002 13:14:50 MST (news.easynews.com) 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" wrote in message news:sl1r8.2537$uH2.256326@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. > >