-- Running this query against your "RecastManagementServer" database will create a new role called "ReadOnlyAccess5" with every read permission enabled. 

SET IDENTITY_INSERT [dbo].[Roles] ON

INSERT INTO [dbo].[Roles] ([Id], [Name])
VALUES
    (5000, 'ReadOnlyAccess5');

INSERT INTO [dbo].[RolePermissions] ([RoleId], [PermissionId])
    VALUES
    (5000, 3),
    (5000, 4),
    (5000, 7),
    (5000, 8),
    (5000, 10),
    (5000, 20),
    (5000, 21),
    (5000, 28),
    (5000, 29),
    (5000, 34),
    (5000, 37),
    (5000, 38),
    (5000, 39),
    (5000, 40),
    (5000, 41),
    (5000, 42),
    (5000, 46),
    (5000, 47),
    (5000, 51),
    (5000, 52),
    (5000, 53),
    (5000, 56),
    (5000, 59),
    (5000, 63),
    (5000, 66),
    (5000, 68),
    (5000, 69),
    (5000, 73),
    (5000, 75),
    (5000, 78),
    (5000, 82),
    (5000, 84),
    (5000, 85),
    (5000, 87),
    (5000, 89),
    (5000, 95),
    (5000, 97),
    (5000, 98),
    (5000, 100),
    (5000, 101),
    (5000, 103),
    (5000, 107),
    (5000, 110),
    (5000, 112),
    (5000, 113),
    (5000, 114),
    (5000, 115),
    (5000, 116),
    (5000, 120),
    (5000, 125),
    (5000, 126),
    (5000, 129),
    (5000, 132),
    (5000, 134),
    (5000, 135),
    (5000, 138),
    (5000, 139),
    (5000, 140),
    (5000, 147),
    (5000, 149),
    (5000, 150),
    (5000, 152),
    (5000, 153),
    (5000, 155),
    (5000, 159),
    (5000, 161),
    (5000, 162),
    (5000, 167),
    (5000, 168),
    (5000, 173),
    (5000, 174),
    (5000, 177),
    (5000, 178),
    (5000, 181),
    (5000, 183),
    (5000, 184),
    (5000, 185),
    (5000, 187),
    (5000, 188),
    (5000, 191),
    (5000, 193),
    (5000, 194),
    (5000, 195),
    (5000, 205),
    (5000, 206),
    (5000, 210),
    (5000, 211),
    (5000, 212),
    (5000, 214),
    (5000, 215),
    (5000, 219),
    (5000, 221),
    (5000, 222),
    (5000, 225),
    (5000, 226),
    (5000, 229),
    (5000, 230),
    (5000, 232),
    (5000, 234),
    (5000, 235),
    (5000, 236),
    (5000, 238),
    (5000, 239),
    (5000, 244),
    (5000, 247),
    (5000, 248),
    (5000, 254),
    (5000, 256),
    (5000, 259),
    (5000, 260),
    (5000, 261),
    (5000, 265),
    (5000, 268),
    (5000, 269),
    (5000, 270),
    (5000, 271),
    (5000, 272),
    (5000, 274),
    (5000, 276),
    (5000, 278),
    (5000, 281),
    (5000, 282),
    (5000, 283),
    (5000, 284),
    (5000, 287),
    (5000, 289),
    (5000, 291),
    (5000, 294),
    (5000, 295),
    (5000, 296),
    (5000, 300),
    (5000, 301),
    (5000, 303),
    (5000, 304),
    (5000, 306),
    (5000, 308),
    (5000, 312),
    (5000, 315),
    (5000, 316),
    (5000, 318),
    (5000, 319),
    (5000, 324),
    (5000, 325),
    (5000, 329),
    (5000, 331),
    (5000, 333),
    (5000, 337),
    (5000, 343),
    (5000, 344),
    (5000, 345),
    (5000, 350),
    (5000, 351),
    (5000, 352),
    (5000, 353),
    (5000, 354),
    (5000, 359),
    (5000, 360),
    (5000, 361),
    (5000, 363),
    (5000, 365),
    (5000, 366),
    (5000, 367),
    (5000, 370),
    (5000, 371),
    (5000, 373),
    (5000, 381),
    (5000, 383),
    (5000, 384),
    (5000, 385),
    (5000, 387),
    (5000, 389),
    (5000, 390),
    (5000, 392),
    (5000, 393),
    (5000, 398),
    (5000, 402),
    (5000, 403),
    (5000, 406),
    (5000, 407),
    (5000, 408),
    (5000, 409),
    (5000, 410),
    (5000, 412),
    (5000, 413),
    (5000, 415),
    (5000, 418),
    (5000, 419),
    (5000, 420),
    (5000, 421),
    (5000, 423),
    (5000, 424),
    (5000, 425),
    (5000, 426),
    (5000, 431),
    (5000, 432),
    (5000, 434),
    (5000, 437),
    (5000, 438),
    (5000, 439),
    (5000, 440),
    (5000, 441),
    (5000, 444),
    (5000, 446),
    (5000, 450),
    (5000, 452),
    (5000, 454),
    (5000, 455),
    (5000, 456),
    (5000, 457),
    (5000, 459),
    (5000, 468),
    (5000, 471),
    (5000, 473),
    (5000, 475),
    (5000, 477),
    (5000, 479),
    (5000, 481),
    (5000, 482),
    (5000, 484),
    (5000, 485),
    (5000, 486),
    (5000, 487),
    (5000, 488),
    (5000, 489),
    (5000, 490),
    (5000, 493),
    (5000, 494),
    (5000, 498),
    (5000, 500),
    (5000, 506),
    (5000, 507),
    (5000, 508),
    (5000, 509),
    (5000, 510),
    (5000, 511),
    (5000, 515),
    (5000, 516),
    (5000, 519),
    (5000, 520),
    (5000, 522),
    (5000, 525),
    (5000, 526),
    (5000, 527),
    (5000, 528),
    (5000, 529),
    (5000, 530),
    (5000, 536),
    (5000, 537),
    (5000, 539),
    (5000, 542),
    (5000, 544),
    (5000, 547),
    (5000, 554),
    (5000, 555),
    (5000, 560),
    (5000, 562),
    (5000, 564),
    (5000, 566),
    (5000, 570),
    (5000, 571),
    (5000, 572),
    (5000, 576),
    (5000, 577),
    (5000, 579),
    (5000, 581),
    (5000, 582),
    (5000, 584),
    (5000, 585),
    (5000, 587),
    (5000, 591),
    (5000, 592),
    (5000, 593),
    (5000, 594),
    (5000, 601),
    (5000, 606),
    (5000, 607),
    (5000, 609),
    (5000, 610),
    (5000, 612);

SET IDENTITY_INSERT [dbo].[Roles] OFF