Inhaltsverzeichnis
keine GliederungFolgendes SQL Statement gibt die Rechte aller Gruppen auf alle Request Templates aus:
SELECT tblTemplate.Id AS TemplateId,tblTemplate.Name AS TemplateName,tblSchemaRequest.Name AS RequestName,tblGroupUserSecurityObject.Rights,Tblgroup.name AS GROUPName
FROM tblTemplate
INNER JOIN tblSchemaRequest ON tblTemplate.SchemaRequest_id = tblSchemaRequest.id
INNER JOIN tblGroupUserSecurityObject ON tblTemplate.id = tblGroupUserSecurityObject.Object_id
INNER JOIN tblGroup ON tblGroupUserSecurityObject.GroupUser_Id = tblGroup.id ;