A quick way to find privileges

Version 1

    When a user gets an error message it is usually straight forward in it's explanation of where the privilege can be found. There are times when users are trying to administrate the privileges and they are having a hard time finding a specific one.  The following script can be used to search the database to find a specific privilege by name.  In the example below it finds all privileges that pertain to the welcome page.

     

    select md_name, md_title from md_privileged_item

    where md_name like '%welcome%'