grz01_at_spray.se wrote:
> 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 ...
Not directly. But you can grant CREATE ANY TABLE.
And then use a DDL event trigger to validate who is doing
what where: RAISE an exception to stop what you don't want.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Mar 07 2007 - 21:14:54 CST
