RE: grant

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Sun, 3 Sep 2000 14:57:36 +0400
Message-Id: <10608.116127@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_01C01595.C94AE314 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,
=A0
To give a grant on any object in another schema, you must have same privilege on that object with grant option.=20 Here dba login also has to have the same privilege for granting on another schema's object, it's not an exception. =A0
=A0=A0=A0 So to achive below task, first login as bob_manager and directly give the privilege to OPS$MBKSAND1. Or else first grant the privilege with grant option to your dba=20 login and then grant it (Looks funny isn't it???) =A0
HTH ,
Rajesh

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jahangir_Shaik
Sent: Sunday, September 03, 2000 2:53 PM To: Multiple recipients of list ORACLE-L Subject: reg:grant

Hello All,=20
I am facing problem while granting privilege to a table existing in one schema to another schema.=20

Following is the command given from DBA account.=20

grant select on bob_manager.dms_agr to OPS$MBKSAND1;=20

Error:FEHLER in Zeile 1:=20
ORA-01031: Unzureichende Berechtigungen=20

I would be greatful if anybody can help me out.=20

Bye,=20
Shaik.Jahangir Basha=20
GE GDC=20 Satyam Computer Services Limited=20
Tel =A0=A0=A0 : +91 40 7846101 Extn 5650=20 E mail: jahangir_shaik_at_hht.satyam.com=20

=_NextPart_001_01C01595.C94AE314 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=us-ascii">
<TITLE>reg:grant</TITLE>

<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>Hi,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>To give a grant on any object in another schema, you</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>must have same privilege on that object with grant option. </SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>Here dba login </SPAN></FONT><FONT color=#0000ff face="Lucida Console" size=2><SPAN class=925275610-03092000>also has to have the same privilege for</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>granting on another schema's object, it's not an exception.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>    So to achive below task, first login as bob_manager</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>and directly give the privilege to OPS$MBKSAND1. Or else</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>first grant the privilege with grant option to your dba
</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>login and then grant it (Looks funny isn't it???)</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>HTH ,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face="Lucida Console" size=2><SPAN
class=925275610-03092000>Rajesh</SPAN></FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

  <DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma   size=2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Jahangir_Shaik<BR><B>Sent:</B>   Sunday, September 03, 2000 2:53 PM<BR><B>To:</B> Multiple recipients of list   ORACLE-L<BR><B>Subject:</B> reg:grant<BR><BR></DIV></FONT>   <P><FONT face=Arial size=2>Hello All,</FONT> <BR><FONT face=Arial size=2>I am   facing problem while granting privilege to a table existing in one schema to   another schema.</FONT> </P>
  <P><FONT face=Arial size=2>Following is the command given from DBA   account.</FONT> </P>
  <P><FONT face=Arial size=2>grant select on bob_manager.dms_agr to   OPS$MBKSAND1;</FONT> </P>
  <P><FONT face=Arial size=2>Error:FEHLER in Zeile 1:</FONT> <BR><FONT   face=Arial size=2>ORA-01031: Unzureichende Berechtigungen</FONT> </P>   <P><FONT face=Arial size=2>I would be greatful if anybody can help me   out.</FONT> </P>
  <P><FONT face=Arial size=2>Bye,</FONT> <BR><FONT color=#000080   face="MS Sans Serif" size=2>Shaik.Jahangir Basha</FONT> <BR><FONT   color=#000080 face="MS Sans Serif" size=2>GE GDC</FONT> </P>   <P><FONT color=#000080 face="MS Sans Serif" size=2>Satyam Computer Services   Limited</FONT> <BR><FONT color=#000080 face="MS Sans Serif" size=2>Tel       : +91 40 7846101 Extn 5650</FONT> <BR><FONT color=#000080   face="MS Sans Serif" size=2>E mail: jahangir_shaik_at_hht.satyam.com</FONT> Received on Sun Sep 03 2000 - 05:57:36 CDT