I've set up users in OneWorld to read only, by assigning them a DB user
which has only read access to the tables in the database (not insert,
delete or update) (ie security at the DB level). It works OK until the
user needs to run a report. Then they need to be able to write a record
in a table (I don't recall which one, where ever Work With Submitted
Jobs searches for entries), or the job cannot be initialised. Remember
though this method is quite indiscriminate - they can see all your
business data. However, using normal application and row security in JDE
you could further secure the data the user can peruse.
Regards,
Mark Suters
ERP8 Update1, SP21_g1, W2K SP3, SQL Server 2000, SP2, Citrix
#####################################################################################
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege
is waived or lost by any mistransmission. If you receive this message in error,
please immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. You must not, directly or indirectly,
use, disclose, distribute, print, or copy any part of this message if you are not
the intended recipient. Stockland and any of its subsidiaries each reserve
the right to monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.
Thank You.
#####################################################################################