delete from SecurityObjects where ObjectName = 'Security'
go
delete from SecurityObjAssociation where ObjectName = 'Security'
go
delete from SecurityObjAccessList where ObjectName = 'Security'
go
delete from SecurityUserTemplates
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Software Manager', 'Packages', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Software Manager', 'Program Groups', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Tech Support', 'Helpdesk', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Tech Support', 'Diagnostics', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Tech Support', 'Queries', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Tech Support', 'Alerts', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Tech Support', 'Site Groups', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Tech Support', 'Events', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Tech Support', 'Sites', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Tech Support', 'Architectures', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Job Manager', 'Jobs', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Job Manager', 'Queries', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Job Manager', 'Events', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Job Manager', 'Architectures', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Job Manager', 'Packages', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Job Manager', 'Sites', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Job Manager', 'Site Groups', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Job Manager', 'Machine Groups', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Asset Manager', 'Queries', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Asset Manager', 'Packages', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Asset Manager', 'Architectures', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Asset Manager', 'Sites', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Asset Manager', 'Events', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Network Monitor', 'Network Monitor', 'RW')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Network Monitor', 'Architectures', 'R')
go
insert into SecurityUserTemplates (TemplateName, ObjectName, AccessRights)
values ('Network Monitor', 'Sites', 'R')
go
update AttributeMap set ValueType = 12
where AttributeName = "Time" and ArchitectureKey = 3
go
delete from SecurityObjAssociation where ObjectName = 'Queries'
go
insert into SecurityObjAssociation (ObjectName,DBObjectName)
values ('Queries', 'Queries')
go
insert into SecurityObjAssociation (ObjectName,DBObjectName)
values ('Queries', 'QueryFormats')
go
insert into SecurityObjAssociation (ObjectName,DBObjectName)
values ('Queries', 'QueryFormatDefaults')
go
insert into SecurityObjAssociation (ObjectName,DBObjectName)
values ('Queries', 'QueryExpressions')
go
sqlexec dbcnv479
