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: Create table, access-rights ?

Re: Create table, access-rights ?

From: <grz01_at_spray.se>
Date: 7 Mar 2007 05:44:35 -0800
Message-ID: <1173275075.375867.220560@n33g2000cwc.googlegroups.com>


On Mar 7, 2:41 pm, g..._at_spray.se wrote:
> Hello,
>
> Short question:
>
> In Oracle, is it possible to grant a user the right
> to create a table in another users schema,
> without granting the right to create in any schema?
>
> I e user A should be allowed to do
>
> CREATE TABLE C.TAB ...
>
> but not
>
> CREATE TABLE C.TAB ...
>
> TIA,
> --------------------------------------grz01

Sorry, typo... the example was meant to read:

User A should be allowed to do

CREATE TABLE B.TAB ... but not

CREATE TABLE C.TAB ... Received on Wed Mar 07 2007 - 07:44:35 CST

Original text of this message

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