Skip to Content
0
Jan 19, 2021 at 07:03 PM

orphan privileges removal - DB stored procedure

68 Views Last edit Jan 19, 2021 at 07:11 PM 2 rev

Hi All,

Good day.

For removing the Orphan privileges, i have tried the below steps same as in the note, but still the PRIVs are not removed from DB.

The source tab query actually given output, so seems not the issue with Source.

Please suggest if i missed some where.

Source :

select L.mcUniqueId, E.mcIDStore from IDMV_LINK_EXT L INNER JOIN IDMV_ENTRY_SIMPLE E ON L.MCTHISMSKEY = E.MCMSKEY where MCTHISMSKEYVALUE = 'XXXX' and MCORPHAN = 1

Des:

$FUNCTION.sap_core_callStoredProcedure(mxi_deleteOrphanAssignment!!'%mcUniqueId%', '%mcIDStore%', 0, 'ADDITIONAL PROCESS INFORMATION')$$

pass Successful. But it shown ToODBC

Pass: Remove orphan PRIVs


Parameter Value Pass type ToODBC

Thanks,

Aravind.