RE: Logon Security

Hi Milind

        Sorry for late Thanks, I was busy with project implementation, anyway I restricted the users by ur logic some how, and tried with roles, anyway its going fine.

        Once again, Thank you very much.
Regards
Raja

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of milind
> Sent: 07 August 2000 10:54
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Logon Security
>
>
>
>
>
> hi Raja
>
>
> Unfortunatly only Certain products can be disabled through
> product_profile...
> like SQL*Plus , SQL*Reportwriter and Oracle Browser..
>
> For diabling SQLPLUS you can use folling query :
>
> insert into product_profile
> (PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE )
> values
> ('SQL*Plus','XYZ','SELECT','DISABLE');
>
> insert into product_profile
> (PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE )
> values
> ('SQL*Plus','XYZ','DELETE','DISABLE');
>
> insert into product_profile
> (PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE )
> values
> ('SQL*Plus','XYZ','CREATE','DISABLE');
>
> ------------------------------------------------------------------
> ---------
> ------------------------------
>
>
>
>
>
> "shanthini rahamath" <shanraha_at_batelco.com.bh> on 06/08/2000 01:43:57 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: milind/DBAMUM01/SHCIL/IN)
>
>
>
>
>
> Hi Milind
> What are the values we have to insert into the table? I also want to
> restrict the user not to connect into the database by third party tools
> like Sqlnavigator or Toad and also through Forms Designer and other oracle
> tools.
> Through some more light on this.
> Thanks & Regards
> Raja
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of milind
> > Sent: 05 August 2000 12:05
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Logon Security
> >
> >
> >
> >
> >
> >
> > Why do'nt you use "product_user_profile" ?.
> >
> >
> > Milind
> >
> >
> >
> >
> > "shanthini rahamath" <shanraha_at_batelco.com.bh> on 05/08/2000 09:55:13 AM
> >
> > Please respond to ORACLE-L_at_fatcity.com
> >
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > cc: (bcc: milind/DBAMUM01/SHCIL/IN)
> >
> >
> >
> >
> >
> > 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 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).
> >
> >
> >
> >
> >
> >
> > --
> > Author: milind
> > INET: milind_at_stockholding.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).
>
> --
> 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 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).
>
>
>
>
>
>
> --
> Author: milind
> INET: milind_at_stockholding.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
Received on Tue Aug 15 2000 - 14:26:54 CDT