Re: Schema permissions

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 17 Jan 2004 06:41:10 -0800
Message-ID: <bQbOb.4043$AA6.3561@fed1read03>

Dr. Franz Fehringer wrote:
> Hello,
>
> Is there a possibilty to achieve with grants: User A can create tables in
> schema B but not in schema C?
>
> Greetings
>
> Dr. Franz Fehringer

There might be a way, but I'm not convinced that it would be worthwhile implementing.

If in schema B a procedure was created such that it could create new tables in schema B, then GRANT EXECUTE ON MAKE_TABLE_IN_B TO A; Received on Sat Jan 17 2004 - 08:41:10 CST

This message: [ Message body ]
Next message: bc_xu_cn: "A Strange Question of Installing oracle 9i on linux7.3"
Previous message: DAVID: "logon_screen_on_error"
In reply to: Dr. Franz Fehringer: "Schema permissions"
Next in thread: Daniel Morgan: "Re: Schema permissions"

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