IBM Security Z Security

Security for Z

Join this online user group to communicate across Z Security product users and IBM experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

type db2_access : Doesen't work with Select USERID=-undef-, And db2auth_grantor<>db2auth_grantee

  • 1.  type db2_access : Doesen't work with Select USERID=-undef-, And db2auth_grantor<>db2auth_grantee

    Posted Mon October 12, 2020 07:54 AM

    Hello,

    I use DB2_ACCESS to create a list/file with all -undef- userid but where grantee is NOT eual to grantor.

    Using the below CARLa down't work well, extract all -undef- but do not exclude grantor=grantee.

    Newlist type=db2_access Name=actbund

    Select DB2ID=DB2Q,

    AND db2_object_type=T,

    AND db2_object_schema=DB2PREP,

    AND userid=-undef-,

    AND db2auth_grantor<>db2auth_grantee

    Sortlist ......


    #Support
    #SupportMigration
    #ZSecurity


  • 2.  RE: type db2_access : Doesen't work with Select USERID=-undef-, And db2auth_grantor<>db2auth_grantee

    Posted Mon October 12, 2020 08:07 AM

    Hello,

    In this case you want to compare the contents of one field against the contents of another field. The CARLa Command Reference describes this in topic "Selecting with a field-field compare", where the field-compare operator for not equal is <<>> or ¬== .

    Try this instead:

    AND db2auth_grantor<<>>db2auth_grantee

    Regards, Mike


    #ZSecurity
    #Support
    #SupportMigration


  • 3.  RE: type db2_access : Doesen't work with Select USERID=-undef-, And db2auth_grantor<>db2auth_grantee

    Posted Mon October 12, 2020 08:11 AM

    Hi,


    Ok my error, now work


    #ZSecurity
    #SupportMigration
    #Support