Skip to content

Loading…

Missing rbac_role_permissions #10794

Closed
ghost opened this Issue · 4 comments

3 participants

@ghost

Core Revision: bd8d0cf
TDB Revision: TDB 335.52 with last updates

There are missing rbac_role_permissions
('219','220','224','228','229','460','720','731','732')
from rbac_permissions

Fix (With incorrect roleId)

INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '219');
INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '220');
INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '224');
INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '228');
INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '229');
INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '460');
INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '720');
INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '731');
INSERT INTO rbac_role_permissions (roleId, permissionId) VALUES ('4', '732');

@Spp-

All those permissions but 460 are not assigned to any role on purpose, those are commands only for console.

460 should be assigned to role 4.

@Spp- Spp- was assigned by Aokromes
@Aokromes
TrinityCore member

base auth.sql needs to be updated.

INSERT INTO `rbac_linked_permissions` (`id`, `linkedId`) VALUES
(196, 460);
@Aokromes Aokromes closed this
@Aokromes Aokromes reopened this
@chaopeng888
DROP TABLE IF EXISTS `rbac_role_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rbac_role_permissions` (
  `roleId` int(10) unsigned NOT NULL COMMENT 'Role id',
  `permissionId` int(10) unsigned NOT NULL COMMENT 'Permission id',
  PRIMARY KEY (`roleId`,`permissionId`),
  KEY `fk__rbac_role_permissions__rbac_permissions` (`permissionId`),
  CONSTRAINT `fk__rbac_role_permissions__rbac_permissions` FOREIGN KEY (`permissionId`) REFERENCES `rbac_permissions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?????';
/*!40101 SET character_set_client = @saved_cs_client */;

like this?

@Aokromes
TrinityCore member

Fixed already.

@Aokromes Aokromes closed this
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.