Ansicht
Dokumentation

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

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

ROGBILLS - Synchronize billing plans   General Material Data  
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


Addresses (Business Address Services)   General Data in Customer Master  
This documentation is copyright by IBM.

Length: 3241 Date: 20240328 Time: 115949     sap01-206 ( 2 ms )