Search for Rights

Use this activity to search for rights.

Activity Steps

1. Access the MSERIG—Rights application from the main menu or quick launch to display the MSERIG—Search Rights screen.
2. Enter the relevant search criteria.

   Right Name is case-sensitive.

   Also, where a Resource Name is supplied (for example, CCSAMPLEPORTION:BIGBOXNAME), then the search is not only performed on the resource name, but applies an additional 'hidden' clause that ALSO returns any right where the ME type Resource (for example, CCSAMPLEPORTION) is in a right. For example:

   select 

         distinct RIGHTSRec.right_name as RIGHT_NAME_0,

         RIGHTSRec.right_description as RIGHT_DESCRIPTION_0,

         RIGHTSRec.core as CORE_0 

   from 

         RIGHTS RIGHTSRec,

         RIGHT_PERMISSIONS RIGHT_PERMISSIONSRec 

   where 

         (RIGHTSRec.right_name = RIGHT_PERMISSIONSRec.right_name) 

         and 

         (RIGHT_PERMISSIONSRec.resource_type = 'AT' 

         and RIGHT_PERMISSIONSRec.resource_name like '%CCSAMPLEPORTION:BIGBOXNAME%' 

         or 

         (RIGHT_PERMISSIONSRec.resource_type = 'ME' 

         and RIGHT_PERMISSIONSRec.resource_name like 'CCSAMPLEPORTION:%')) 

   order by 

   RIGHTSRec.right_name

   The net affect is that this search cannot be used to find rights that ONLY have that a specific resource. (Not very useful when attempting to locate all the custom rights that have a specific resource, custom or otherwise.)

   Likewise, when the specific resource is opened in the MSEREA—Resource Authorisation Update screen, the tab displaying the rights that includes the resource also does the same kind of search.

3. Click Submit.

   Note: Both core and custom rights are returned from the search.