Re: How can a 'non-owner' grant access to a table.

From: <sybrandb_at_yahoo.com>
Date: 7 Jun 2004 01:37:58 -0700
Message-ID: <a1d154f4.0406070037.5f07db80_at_posting.google.com>

"David Pylatuk" <davepylatuk_at_centurysystems.net> wrote in message news:<MKZvc.37079$Hn.1208160_at_news20.bellglobal.com>...
> Could you clarify please.
>
> Do you mean the owner must have granted with admin to the role ?
>

Yes, I did mean that. Otherwise, no joy, unless you are on 9i and use SYS to bypass security. Grants made by SYS, however, are not exported in a logical dump, as SYS is not exported

Sybrand Bakker
Senior Oracle DBA Received on Mon Jun 07 2004 - 10:37:58 CEST

This message: [ Message body ]
Next message: Tony: "Re: Fine Grained Acces Control & cursor"
Previous message: sybrandb_at_yahoo.com: "Re: How to make a table insert trigger to hit a servlet?"
Maybe in reply to: David Pylatuk: "How can a 'non-owner' grant access to a table."
In reply to David Pylatuk: "Re: How can a 'non-owner' grant access to a table."
Next in thread: Tony: "Re: Fine Grained Acces Control & cursor"

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

Original text of this message