Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

?--Turn on ability to insert identity (primary key)
SET IDENTITY_INSERT seclyr.Roles ON;
GO

INSERT INTO seclyr.Roles (RoleID, RoleName, [Description])
VALUES
(1, N'Administrator', N'This is the business administrator for the application, primarily responsible for managuing user accounts and FAQ type information')
, (2, N'Supervisor', N'This role would have slightly higher access the the User role. Use based on business requirements')
, (3, N'User', N'This is the basic role with limited accessibility to the basic functionality')
, (4, N'Support', N'This role allows access to all aspects of the application including setting maintenace notifications and menu management')
, (5, N'Account Mgr', N'In some busimess applications, it may be desired to have aseperate role for managing user accounts, separate from other business administration.')


--Turn off ability to insert identity (primary key)
SET IDENTITY_INSERT seclyr.Roles OFF;
GO