Users and Emails Under a Certain Role

Your rating: None Average: 2.7 (3 votes)

The query will help you find users with their email addresses for a certain Role Name.

SELECT emailid
FROM psoprdefn
, psrolemember
WHERE rolename = :role_name
AND oprid = roleuser
AND emailid <> ' '

For example, you could run the query to get email addresses for users who have a role name of "Developer".

Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!


Have a question? Please ask it on the forum instead.

Post new comment

The content of this field is kept private and will not be shown publicly.
The question below is to prevent automated spam submissions.
2 + 2 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.