PPM User Discussions

Query for Users and their Security Groups

Bryan Legaspi 1 month ago

Hi,

I just want to ask for an SQL query for the security group each users belong?

Thanks and regards,

Bryan

Tags:

user

Security Group

SQL

query

Top Replies

Etienne Canaud 1 month ago +1 verified

SELECT u.username USERNAME, u.full_name FULL_NAME, u.email_address EMAIL, u.end_date END_DATE, sg.security_group_name SECURITY_GROUP from knta_security_groups_nls sg, knta_user_security us, knta_users…

Verified Answer

+1 Etienne Canaud OpenText Employee

1 month ago

SELECT u.username USERNAME, u.full_name FULL_NAME, u.email_address EMAIL, u.end_date END_DATE, sg.security_group_name SECURITY_GROUP
from knta_security_groups_nls sg, knta_user_security us, knta_users u
 where u.user_id = us.user_id and sg.security_group_id = us.security_group_id
 order by u.last_name, u.first_name

Note that this will also include disabled Security Groups.

0 Bryan Legaspi 1 month ago in reply to Etienne Canaud

Thank you so much Etienne!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Menu

PPM User Discussions

Verified Answers

Query for Users and their Security Groups

Tags:

Top Replies

Verified Answer

Resources