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');