Useful SQL Queries for getting authorized Security Groups and Users for specific application and security option

Getting an authorized Security Groups

select * from APPLICATIONAUTH order by GROUPNAME, APP;
select * from APPLICATIONAUTH where APP = 'SR' and optionname = 'READ';

Getting an authorized User list

select * from GROUPUSER;
select * from GROUPUSER where GROUPNAME in (select GROUPNAME from APPLICATIONAUTH where APP = 'SR' and optionname = 'READ');