Hello bonju,
Running this on the database should give you enough permissions to manage permissions:
IF NOT EXISTS(SELECT 1 FROM [Groups] WHERE [Group_Name] = 'Administrators')
INSERT INTO [Groups] ([Group_Name]) VALUES ('Administrators')
IF NOT EXISTS(SELECT 1 FROM [UserGroups] WHERE [User_Name] = 'Admin' AND [Group_Name] = 'Administrators')
INSERT INTO [UserGroups] ([User_Name], [Group_Name]) VALUES ('Admin', 'Administrators')
DECLARE @AdministerRole INT
SET @AdministerRole = (SELECT [Role_Id] FROM [Roles] WHERE [Role_Name] = 'Administer')
IF @AdministerRole IS NULL
BEGIN
INSERT INTO [Roles] ([Role_Name], [Role_Description], [FeedScopable_Indicator]) VALUES ('Administer', 'Allows unrestricted access to all functionality within ProGet.', 'N')
SET @AdministerRole = SCOPE_IDENTITY();
END
IF NOT EXISTS(SELECT 1 FROM [RoleTasks] RT INNER JOIN [Tasks] T ON RT.[Task_Id] = T.[Task_Id] WHERE RT.[Role_Id] = @AdministerRole AND T.[Task_Name] = 'Admin_ConfigureProGet')
INSERT INTO [RoleTasks] ([Role_Id], [Task_Id]) VALUES (@AdministerRole, (SELECT [Task_Id] FROM [Tasks] WHERE [Task_Name] = 'Admin_ConfigureProGet'))
IF NOT EXISTS (SELECT 1 FROM [Privileges] WHERE [Principal_Name] = 'Administrators' AND [PrincipalType_Code] = 'G' AND [Role_Id] = @AdministerRole AND [Feed_Id] IS NULL AND [PrivilegeType_Code] = 'G' AND [UserDirectory_Id] = 1)
INSERT INTO [Privileges] ([Principal_name], [PrincipalType_Code], [Role_Id], [Feed_Id], [PrivilegeType_Code], [UserDirectory_Id]) VALUES ('Administrators', 'G', @AdministerRole, NULL, 'G', 1)
If it gives back an error about Cannot insert the value NULL into column 'Task_Id', that means the Tasks table is probably missing some values, and I can help with that if that's the case.