Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: How can a 'non-owner' grant access to a table.

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@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 - 03:37:58 CDT












Original text of this message













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