Thanks for the quick reply. I may not have actually explained very well what I was looking for.

Basically, I need help with a script that will show my all the users in the system( select * from apps.fnd_user table ) and what the default printer is for each of them. I can do this in the application, but that would take a very long time to pull up 1500 users going one at a time. Yes, I am trying to find the easy way out. :P

We are using E-Business Suite. You navigate to system Administrator, Profile, System. You can then type in the username and enter 'PRINTER' as the Profile name. This form will then show you the the printer that is defaulted for that user.

Thanks for the help!

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


Oracle LazyDBA home page