We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

CPD5031 - Object and column level authorities do not match. ( OS/400 )

CPD5031 - Object and column level authorities do not match. ( OS/400 )

General Data in Customer Master   Vendor Master (General Section)  
This documentation is copyright by IBM.
SAP E-Book


Message : CPD5031
Object and column level authorities do not match.

Message Long Text :

Cause . . . . . : User profile &3 has a column level authority but does not have the corresponding object level authority. For example, the user may have update authority to a field in the file, but does not have update authority to the file itself. This may have been caused by having deleted the file, and then having restored the file from media.
Recovery . . . : Issue a DSPOBJAUT (Display Object Authority) command for file &1 in library &2. Press the F16 key in order to display the field authorities. Then ask either the security officer or the owner of the file to follow the next four steps:
1 -- If any of the fields have references authority, issue a SQL Grant request to grant references authority again to one of these fields.
2 -- If any of the fields have update authority, issue a SQL Grant request to grant update authority again to one of these fields.
3 -- If any of the fields have both management authority and references authority, issue a SQL Grant request to grant both the references authority and the With Grant Option again to one of these fields.
4 -- If any of the fields have both management authority and update authority, issue a SQL Grant request to grant both the update authority and the With Grant Option again to one of these fields.
By granting these authorities to single fields, all of the other field level authorities for user profile &3 will be made available again. You do not need to issue SQL Grant requests for each field that has field level authorities.

Message File : QCPFMSG
Library Message File : QSYS2924


SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by IBM.

Length: 3241 Date: 20201025 Time: 090629     sap01-206 ( 1 ms )