This example shows a NEW_RIGHTS alert that is run daily to send a notification that lists users with new privileges. The message contains wildcards for the user’s first and last names, as well as the new privileges. The e-mail subject will have NEW_RIGHTS in the title. The e-mail message in the body will contain the Message Returned text and the SQL results.
The Alert Code value is included in the message subject, defined in the Email Header field: ‘EWQ: NEW_RIGHTS’
The Message Returned text is defined as: ‘The user %2 %3 has recently gained %1 rights’
The SQL statement entered in the Query Text field is defined as:
SELECT pr.priv_code,
us.first_name,
us.last_name
FROM m_users us, m_us_privs up, m_privs pr
WHERE us.us_id = up.us_id
AND pr.priv_id = up.priv_id
You can place the SQL results anywhere in the phrase, as long as you use the correct order number. In the SQL statement example, %1, %2, and %3 are priv_code, first_name, and last_name, respectively.
Example of the e mail body: