I'm not aware of Oracle keeping track of default printers for a user.
I'd be interested to see if someone has this information. You can see
all the users in the database via:

Select username from dba_users;

-----Original Message-----
From: Ronnie Smith
[mailto:oracledba-ezmlmshield-x98114905.[Email address protected]
Sent: Friday, February 29, 2008 1:30 PM
To: LazyDBA Discussion
Subject: Re: User Profile Script

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



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





******************************************************************************************
The information contained in this message, including attachments, may contain
privileged or confidential information that is intended to be delivered only to the
person identified above. If you are not the intended recipient, or the person
responsible for delivering this message to the intended recipient, Alltel requests
that you immediately notify the sender and asks that you do not read the message or its
attachments, and that you delete them without copying or sending them to anyone else.



Oracle LazyDBA home page