| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Giving grants
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_01C0372D.8515D370
Content-Type: text/plain;
charset="iso-8859-1"
Hi,
You will have to grant the required privileges to user X like:
Grant insert, update, delete, select
on table_name
to x ( or a role to which x has access);
Determine the privileges you have to give on your tables.
Thanks,
Amar
00-971-50-7883254
ts2017_at_emirates.com
amar_padhi_at_hotmail.com
amar_padhi_at_musclemail.com
-----Original Message-----
From: satish plakote [mailto:satish_plakote_at_excite.com]
Sent: Monday, October 16, 2000 9:01 AM
To: Multiple recipients of list ORACLE-L
Subject: Giving grants
hi,
i have a set of tables in a database which is created and owned by me,now i
want to grant only limited privileges to user 'X' on those tables, so that
he can carry on with his daily work.
I am not sure of the syntax of the sql stmt to be issued.
Can somebody help!
Thanks
satish
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: satish plakote INET: satish_plakote_at_excite.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_01C0372D.8515D370 Content-Type: text/html; charset="iso-8859-1"Received on Sun Oct 15 2000 - 23:57:01 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2652.35">
<TITLE>RE: Giving grants</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Hi,</FONT>
<BR><FONT SIZE=2>You will have to grant the required privileges to user X like:</FONT>
<BR><FONT SIZE=2> Grant insert, update, delete, select </FONT>
<BR><FONT SIZE=2> on table_name</FONT>
<BR><FONT SIZE=2> to x ( or a role to which x has access);</FONT>
</P>
<P><FONT SIZE=2>Determine the privileges you have to give on your tables.</FONT>
</P>
<P><FONT SIZE=2>Thanks,</FONT>
<BR><FONT SIZE=2>Amar</FONT>
<BR><FONT SIZE=2>00-971-50-7883254</FONT>
<BR><FONT SIZE=2>ts2017_at_emirates.com</FONT>
<BR><FONT SIZE=2>amar_padhi_at_hotmail.com</FONT>
<BR><FONT SIZE=2>amar_padhi_at_musclemail.com</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: satish plakote [<A HREF="mailto:satish_plakote_at_excite.com">mailto:satish_plakote_at_excite.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, October 16, 2000 9:01 AM</FONT>
<BR><FONT SIZE=2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=2>Subject: Giving grants</FONT>
</P>
<BR>
<P><FONT SIZE=2>hi,</FONT>
<BR><FONT SIZE=2>i have a set of tables in a database which is created and owned by me,now i</FONT>
<BR><FONT SIZE=2>want to grant only limited privileges to user 'X' on those tables, so that</FONT>
<BR><FONT SIZE=2>he can carry on with his daily work.</FONT>
<BR><FONT SIZE=2>I am not sure of the syntax of the sql stmt to be issued.</FONT>
<BR><FONT SIZE=2>Can somebody help!</FONT>
<BR><FONT SIZE=2>Thanks </FONT>
<BR><FONT SIZE=2>satish</FONT>
</P>
<BR>
<BR>
<BR>
<BR>
<P><FONT SIZE=2>_______________________________________________________</FONT>
<BR><FONT SIZE=2>Say Bye to Slow Internet!</FONT>
<BR><FONT SIZE=2>http://www.home.com/xinbox/signup.html</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Please see the official ORACLE-L FAQ: http://www.orafaq.com</FONT>
<BR><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>Author: satish plakote</FONT>
<BR><FONT SIZE=2> INET: satish_plakote_at_excite.com</FONT>
</P>
<P><FONT SIZE=2>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=2>San Diego, California -- 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). You may</FONT>
<BR><FONT SIZE=2>also send the HELP command for other information (like subscribing).</FONT>
 |
 |