RE: Granting Select Any Table

From: Larry Taylor <ltaylor_at_iq.com>
Date: Thu, 14 Dec 2000 12:58:07 -0800
Message-Id: <10710.124627@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C06610.8F7540F0
Content-Type: text/plain;

charset="iso-8859-1"

Not really, what I want is to grant user Scott select any table owned by user Mike.

-----Original Message-----
From: Sais, Gene [mailto:gsais_at_qode.com] Sent: Thursday, December 14, 2000 10:57 AM To: Multiple recipients of list ORACLE-L Subject: RE: Granting Select Any Table

You answered it yourself :) grant select any table to user;

-----Original Message-----
From: Larry Taylor [ mailto:ltaylor_at_iq.com <mailto:ltaylor_at_iq.com> ] Sent: Thursday, December 14, 2000 12:44 PM To: Multiple recipients of list ORACLE-L Subject: Granting Select Any Table

Hi folks,

Does anyone know the best way to grant a user select any table of another users tables?

Thanks in advance

Larry

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<http://www.orafaq.com>  
-- 
Author: Larry Taylor 
  INET: ltaylor_at_iq.com 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 
San Diego, California        -- Public Internet access / Mailing Lists 
-------------------------------------------------------------------- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 


------_=_NextPart_001_01C06610.8F7540F0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Granting Select Any Table</TITLE>

<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=619545620-14122000><FONT face=Arial color=#0000ff size=2>Not 
really, what I want is to grant user Scott select any&nbsp; table owned by user 
Mike.</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">


  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 

  size=2>-----Original Message-----<BR><B>From:</B> Sais, Gene 
  [mailto:gsais_at_qode.com]<BR><B>Sent:</B> Thursday, December 14, 2000 10:57 
  AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: 
  Granting Select Any Table<BR><BR></FONT></DIV>


  <P><FONT size=2>You answered it yourself :)&nbsp; grant select any table to 

  user;</FONT> </P>


  <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Larry 

  Taylor [<A href="mailto:ltaylor_at_iq.com">mailto:ltaylor_at_iq.com</A>]</FONT> 


  <BR><FONT size=2>Sent: Thursday, December 14, 2000 12:44 PM</FONT> <BR><FONT 

  size=2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT 
  size=2>Subject: Granting Select Any Table</FONT> </P><BR>


  <P><FONT size=2>Hi folks,</FONT> </P>

  <P><FONT size=2>Does anyone know the best way to grant a user select any table 

  of another</FONT> <BR><FONT size=2>users tables?</FONT> </P>


  <P><FONT size=2>Thanks in advance</FONT> </P>

  <P><FONT size=2>Larry</FONT> <BR><FONT size=2>-- </FONT><BR><FONT 

  size=2>Please see the official ORACLE-L FAQ: <A target=_blank 
  href="http://www.orafaq.com">http://www.orafaq.com</A></FONT> <BR><FONT 
  size=2>-- </FONT><BR><FONT size=2>Author: Larry Taylor</FONT> <BR><FONT 
  size=2>&nbsp; INET: ltaylor_at_iq.com</FONT> </P>


  <P><FONT size=2>Fat City Network Services&nbsp;&nbsp;&nbsp; -- (858) 

  538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT size=2>San Diego, 
  California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet access 
  / Mailing Lists</FONT> <BR><FONT 
  size=2>--------------------------------------------------------------------</FONT> 


  <BR><FONT size=2>To REMOVE yourself from this mailing list, send an E-Mail 

  message</FONT> <BR><FONT size=2>to: ListGuru_at_fatcity.com (note EXACT spelling 
  of 'ListGuru') and in</FONT> <BR><FONT size=2>the message BODY, include a line 
  containing: UNSUB ORACLE-L</FONT> <BR><FONT size=2>(or the name of mailing 
  list you want to be removed from).&nbsp; You may</FONT> <BR><FONT size=2>also 
  send the HELP command for other information (like subscribing).</FONT>

Received on Thu Dec 14 2000 - 14:58:07 CST