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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Logon Security

RE: Logon Security

From: shanthini rahamath <shanraha_at_batelco.com.bh>
Date: Mon, 7 Aug 2000 20:23:33 +0300
Message-Id: <10582.113987@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_000F_01C000AD.5C0D6DA0
Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi Hamil
  Thanks for your reply.
  I want to restrict user not not connect to the database using sqplus or any other developement tools.
Cheers
Raja
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Chuck Hamilton
  Sent: 07 August 2000 17:37
  To: Multiple recipients of list ORACLE-L   Subject: Re: Logon Security

   Let me make sure I'm understanding what you want to do correctly. You want to run a report and during that time disable other users from being able to log in. Is that correct? If so then just enable restricted session mode during the report and disable it when done.

  alter system enable restricted session;   run the report.
  alter system disable restricted session;

    shanthini rahamath <shanraha_at_batelco.com.bh> wrote:

    Dear Gurus
    Environment
    Client : Developer 1.3.2
    Database : Oracle 7.3 in Unix box
    OS : Window 98

  1. For security purpose, how can restrict users not to connect to the database through sqlplus or forms desinger and reports designer. Is there any way to implement this.
  2. I need report to be run in a regular interval of time and send the output to printer. The report is developed in report writer 1.3.2 and I am calling this report from forms 4.5 and the database is 7.3. Is there anyway to implement this. Thanks in advance.

    Thanks & Regards
    Raja

    --
    Author: shanthini rahamath
    INET: shanraha_at_batelco.com.bh

    Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051     San Diego, California -- Public Internet access / Mailing Lists



    To REMOVE yoursel! ! f 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).

--

  Do You Yahoo!?
  Kick off your party with Yahoo! Invites.

------=_NextPart_000_000F_01C000AD.5C0D6DA0
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff><SPAN class=3D480421517-07082000>Hi=20
Hamil</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff><SPAN class=3D480421517-07082000>&nbsp; = Thanks for your=20
reply.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff><SPAN class=3D480421517-07082000>&nbsp; I = want to=20
restrict user not not connect to the database using sqplus or any other=20 developement tools.</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff><SPAN=20
class=3D480421517-07082000>Cheers</SPAN></FONT></DIV>
<DIV><FONT color=3D#0000ff><SPAN =
class=3D480421517-07082000>Raja</SPAN></FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: = 5px">
  <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr><FONT = face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Chuck = Hamilton<BR><B>Sent:</B> 07=20
  August 2000 17:37<BR><B>To:</B> Multiple recipients of list=20   ORACLE-L<BR><B>Subject:</B> Re: Logon Security<BR><BR></DIV></FONT>   <P>&nbsp;Let me make sure I'm understanding what you want to do = correctly. You=20
  want to run a report and during that time disable other users from = being able=20
  to log in. Is that correct? If so then just enable restricted session = mode=20
  during the report and disable it when done.=20   <P>alter system enable restricted session;<BR>run the report.<BR>alter =

  system&nbsp;disable restricted session;<BR></P>   <P>&nbsp; <B><I>shanthini rahamath =
&lt;shanraha_at_batelco.com.bh&gt;</I></B>=20   wrote: <BR>
  <BLOCKQUOTE=20
  style=3D"BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; = PADDING-LEFT: 5px">Dear=20

    Gurus<BR>Environment<BR>Client : Developer 1.3.2<BR>Database : = Oracle 7.3 in=20

    Unix box<BR>OS : Window 98<BR>1. For security purpose, how can = restrict=20

    users not to connect to the<BR>database through sqlplus or forms = desinger=20

    and reports designer. Is there<BR>any way to implement this.<BR>2. I = need=20

    report to be run in a regular interval of time and send = the<BR>output to=20

    printer. The report is developed in report writer 1.3.2 and I = am<BR>calling=20

    this report from forms 4.5 and the database is 7.3. Is there = anyway<BR>to=20

    implement this.<BR>Thanks in advance.<BR><BR>Thanks &amp;=20     Regards<BR>Raja<BR><BR>-- <BR>Author: shanthini rahamath<BR>INET:=20     shanraha_at_batelco.com.bh<BR><BR>Fat City Network Services -- (858) = 538-5051=20

    FAX: (858) 538-5051<BR>San Diego, California -- Public Internet = access /=20

    Mailing=20
    =

Lists<BR>----------------------------------------------------------------=

----<BR>To=20

    REMOVE yoursel! ! f from this mailing list, send an E-Mail = message<BR>to:=20

    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = in<BR>the=20

    message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the = name of=20

    mailing list you want to be removed from). You may<BR>also send the = HELP=20
    command for other information (like subscribing).</BLOCKQUOTE>

  <P><BR>
  <HR SIZE=3D1>
  <B>Do You Yahoo!?</B><BR>Kick off your party with <A=20
Received on Mon Aug 07 2000 - 12:23:33 CDT

Original text of this message

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