Re: Where is WRKFCNUSG stored

there are some function usage API's

The user function registration APIs are:

Change Function Usage Information (QSYCHFUI, QsyChangeFunctionUsageInfo) changes the usage information for a function, such as which user profiles are allowed to use a function.

Check User Function Usage (QSYCKUFU, QsyCheckUserFunctionUsage) whether a user is allowed to use the specified function and returns an indication of whether the user is allowed to use the function.

Deregister Function (QSYDRGFN, QsyDeregisterFunction) removes a function and all associated usage information from the registration facility.

Register Function (QSYRGFN, QsyRegisterFunction) registers a function with the registration facility.

Retrieve Function Information (QSYRTVFI, QsyRetrieveFunctionInformation) retrieves information about one or more functions.

Retrieve Function Usage Information (QSYRTFUI, QsyRetrieveFunctionUsageInfo) retrieves usage information for a function.

Retrieve User Function Information (QSYRTUFI, QsyRetrieveUserFunctionInfo) retrieves usage settings for a specified user profile for one or more functions.


https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/apis/sec4.htm


maybe it will help...



Bryan



DRIVER Adam ResgGtsMktSrv wrote on 2/3/2020 1:43 PM:

Thanks Rob,

Noted! And you're probably right. I'll see what I can track down from audit journals though.

Thanks

Adam DRIVER
AME - RESG/GTS/MFR/AS400
425 S. Financial Pl, 24th Floor
Chicago, IL 60605
Tel.: +1 312.762.1194
Cell: +1 224.250.9049
Team: +1 312.762.1125
Email: adam.driver@xxxxxxxxxx<mailto:adam.driver@xxxxxxxxxx>

www.sgcib.com<http://www.sgcib.com/>
Primary CI: AS400
Assignment Group: gts-wwi-ssb-app-as400
Team Email: amer-gts-mkt-ssb-as400-team
Tel (24 hrs): 312 762 1125

Any new support request should be sent to the first level at helpdesk@xxxxxxxxxxxxxxxxxxx<mailto:helpdesk@xxxxxxxxxxxxxxxxxxx>
[http://insite.fr.world.socgen/ecard/images/logo_legal_l.gif][http://insite.fr.world.socgen/ecard/images/logo_legal_r.gif]
------------------------------------------------------------------

I thought about changing one and then looking at the system audit journals but figured you can do that kind of experimenting on your own system.



You can do about anything with SQL. It may require you to create your own stored procedure, table function, user defined function, either written in SPL or some other language to do it though. ;-)



And if you do find the location don't assume it will be in the same place at the next release. There's a reason IBM tries to funnel you through APIs.



Also, I wouldn't put it past IBM to put these in IFS or some other place and use weird permissions or attributes to control whether user based programs can update them. But you may get lucky.



Rob Berendt

--

IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive

Garrett, IN 46738

Ship to: Dock 108

6928N 400E

Kendallville, IN 46755

http://www.dekko.com

*************************************************************************
This message and any attachments (the "message") are confidential, intended
solely for the addressee(s), and may contain legally privileged information.
Any unauthorized use or dissemination is prohibited. E-mails are susceptible
to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or
affiliates shall be liable for the message if altered, changed or falsified.
Please visit http://sgasdisclosure.com for important information regarding
SG Americas Securities, LLC ("SGAS"). Please visit http://swapdisclosure.sgcib.com
for important information regarding swap transactions with SOCIETE GENERALE.
*************************************************************************