Re: tablespace creation and privileges

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 5 Apr 2002 06:15:47 +1000
Message-ID: <a8icc1$u9b$1@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:15:47 CST