User has no access to Component Interface - Security

Use the following to compare a user that does have access to a user that doesn't. Provide the user that does, the user that doesn't, and the CI name.

Will return the Role, Permission List that is missing.


select * from (
select
  r.rolename
, c.oprclass
, ci.bcname
from
  PSOPRCLS c
, PSROLECLASS r
, PSAUTHBUSCOMP ci
where c.oprid = 'E87637'  -- User that DOES have access.
and r.classid = c.oprclass
and ci.classid = c.oprclass

minus

select
  r.rolename
, c.oprclass
, ci.bcname
from
  PSOPRCLS c
, PSROLECLASS r
, PSAUTHBUSCOMP ci
where c.oprid = 'S3286436' -- User that is missing access
and r.classid = c.oprclass
and ci.classid = c.oprclass

--) where bcname like 'HCR_PERSONAL_DATA_SRV'
) where bcname like 'AMS_CI_CHESSN_DATA'

0 comments: