[QUOTE][i]Originally posted by hrishy [/i]
[B]have you tried pupbld.sql package glogin.sql look at these options to [/B][/QUOTE]

Can you ellaborate what have you had in mind with the above statement?

Maybe you haven't follow this thread from the begining. The original question was "How to assure users have their needed privileges enaibled only when they are connected through certain applicaton, and disable all the privileges for the same users when they try to connect through any other aplication or tool (like SQP*Plus)?".

Both pupbld and glogin.sql are efective only for SQL*Plus and no other tool or aplication. How would you use those two scripts to achieve the above requirenments???