Tom,

Thank you.
Was appreciated !!!!

-----Original Message-----
From: Terrian, Tom (Contractor) (DAASC) [mailto:Tom.[Email Address Removed] Tuesday, September 30, 2003 1:45 PM
To: 'Rusnak, George A. (SEC-Lee) CTR'; LazyDBA.com Discussion
Subject: RE: SQL Plus host command


Add the following to the system.product_user_profile table for each user:

Insert into system.product_user_profile(product,attribute,userid,char_value)
Values ('SQL*Plus','HOST',<their user id>, 'DISABLED');


-----Original Message-----
From: Rusnak, George A. (SEC-Lee) CTR [mailto:george.[Email Address Removed]
Sent: Tuesday, September 30, 2003 1:06 PM
To: LazyDBA.com Discussion
Subject: SQL Plus host command


Ladies and gentlemen,

Is there ANYWAY to block the host command? We would like to allow certain
users
access to SQLPlus but do not want them to be able to host out.


TIA

Al Rusnak
DBA - WEB Team

* 804-734-8371
* george.[Email Address Removed] documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page