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

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.
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</DIV>
<DIV>  = Thanks for your=20
reply.</DIV>
<DIV>  I = want to=20
restrict user not not connect to the database using sqplus or any other=20 developement tools.</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>-----Original Message----- From: root_at_fatcity.com=20 [mailto:root_at_fatcity.com]On Behalf Of Chuck = Hamilton Sent: 07=20
 August 2000 17:37 To: Multiple recipients of list=20 ORACLE-L Subject: Re: Logon Security </DIV>  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 alter system enable restricted session; run the report. alter =

system disable restricted session;   shanthini rahamath =
<shanraha_at_batelco.com.bh>=20 wrote: 
 <BLOCKQUOTE=20
 style=3D"BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; = PADDING-LEFT: 5px">Dear=20

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

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

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

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

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

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

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

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

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

Mailing=20
=

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

---- To=20

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

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

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

mailing list you want to be removed from). You may 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