I am needing to disable/delete a printer in our apps that is no longer available. It keeps telling me it is referenced. I can only think it is still assigned to a couple users as a default printer. It may also be tied to some end dated users.

Can anyone think of a script to show all the users and the default printers that are assigned to each one? We are using apps 11.5.10.2 and the database is 9.2 I believe.

Thanks!

Ronnie D Smith
Rose Acre Farms
IT Dept
Phone: 812-497-2559 ext 290
fax: 812-497-3311


Oracle LazyDBA home page