Re: tablespace creation and privileges

From: Achal Tandon <achalt_at_indiainfo.com>
Date: 4 Apr 2002 15:32:02 -0800
Message-ID: <c73ef45b.0204041532.5a74c5e@posting.google.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.

use the following to grant tablespace creation privilege to scott.

grant create tablespace to scott; Received on Thu Apr 04 2002 - 17:32:02 CST

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: Installing Oracle 8.0.4 on Windows 2000 server/professional"
Previous message: Félix: "How do I create a XML document using the XDK for PLSQL?"
In reply to: ayrobins: "tablespace creation and privileges"
Next in thread: RSH: "Re: tablespace creation and privileges"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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