12/04/2017

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');

No comments:

Post a Comment