Security tables

Can anyone tell me which system tables deal with OneWorld security?

Any help is appreciated. Thanks.

Stacy
XE SP16.1 Upd 2 W2K SQLSvr 2K

User or system security?

OneWorld Xe Sp16_018, W2k, W2K TSE, SQL 2K on Compaq Proliant.

Hi Stacy,

Security workbench uses F00950 in the JDE7333 database. We have an Access database that does bulk copies into this table for user/group security.

I hope this is what you were looking for.

Kevin

OneWorld Xe SP17.1 XU3
Intel NT, SQL 7.0 SP3
Citrix Metaframe 1.8

For user security: the system datasource (SYS7333) file: F0092*, F98OWSEC.

Jean Driscoll
AS/400 Co-existent Xe SP15+17.1, Update 1/A73Cum12

All Security tables. Even Solutions Explorer. Why I'm asking is we
have two separate installs and want to keep the security consistent
between the two.

Thanks.

Stacy Barry
Xe Sp16.1, Upd 2, W2k, SQL 2K

Look in the system admin manual for a better answer and explanation.
OneWorld security is controlled by several tables.

User Profiles - F0092
User Display Preferences F00921
User Display Preferences Tag File - F00922
User Access Definition - F00925
OneWorld Security Table - F98OWSEC
Security Workbench - F00950

Also, the 'Complete Reference' book has an excellent overview of how
OneWorld security works.

Colin Dawes
B733.2 SP17.1_F1
Intel/NT/Oracle 8.1.7.1

Thank you Colin. Now I know where to look.

Stacy Barry