RBAC(?? ?? ??? ??) ?? ?? ??? ?????.

1. ?? ????: ???? ?? ?? ?? ?? ??? ????, ???? ??? ????, ?? ??? ?? ???? ?? ???? ??? ?????. ??? ???? ?? ??? ???? ?? ??? ??? ?? ?? ??? ?? ??????. (?? ??:##yii Framework)#???? ## ????#1) ??: ?? ? ??? ???? ??? ? ????. ?? ?? ?? ?????? "?? ???"? "???"? ?????.

2) ??: ???? ??? ???? ???? ??? ???? ???? ?? ??? ????.

Yii2?? rbac ??

1.Yii2? ???? ??? RBAC? ????, ??? ??? NIST RBAC ?????. .

2. yii2? ????? ??? ???????.

?: ?? ???? ?? ???? ?? ???? ?? ???? ??? ?? ?? ??? ??? ? ??? ?? ???? ??? ??? ??? ?? ??? ??? ? ????. ?, ?? ???? ??? ??? ??? ??? Extra? ?? ??? ??? ??? ??? ? ??? ????. Extra? ??? ??? ??? ?? ??????.

3.yii2? ?? ?? ??? ??? db?? ? ?? ???? ?????. db ?? ??? ???

???. 1) ?? ?? ??? ???? ???: auth_item (??: 1? ??, 2? ??? ??)

CREATE TABLE `auth_item` (
`name` varchar(64) NOT NULL,
`type` int(11) NOT NULL,
`description` text,
`rule_name` varchar(64) DEFAULT NULL,
`data` text,
`created_at` int(11) DEFAULT NULL,
`updated_at` int(11) DEFAULT NULL,
PRIMARY KEY (`name`),
KEY `rule_name` (`rule_name`),
KEY `type` (`type`),
CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

2) ?? ? ??? ?? ?? ???: auth_item_child#???? #

(?? ??: ??? ??? ??? ? ??, ??? ??? ??? ? ???, ??? ??? ??? ? ??? ??? ??? ??? ? ??)

CREATE TABLE `auth_item_child` (
`parent` varchar(64) NOT NULL,
`child` varchar(64) NOT NULL,
PRIMARY KEY (`parent`,`child`),
KEY `child` (`child`),
CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

3) ??? ? ?? ?? ???(??): auth_rule

CREATE TABLE `auth_assignment` (
`item_name` varchar(64) NOT NULL,
`user_id` varchar(64) NOT NULL,
`created_at` int(11) DEFAULT NULL,
PRIMARY KEY (`item_name`,`user_id`),
CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8

4) ?? ???: auth_rule

CREATE TABLE `auth_rule` (  
  `name` varchar(64) NOT NULL,  
  `data` text,  //存的是一個(gè)序列化的實(shí)現(xiàn)了yii\rbac\Rule接口的類的一個(gè)對(duì)象實(shí)例
  `created_at` int(11) DEFAULT NULL,  
  `updated_at` int(11) DEFAULT NULL,  
  PRIMARY KEY (`name`),  
  KEY `name` (`name`),  
  KEY `created_at` (`created_at`),  
  KEY `updated_at` (`updated_at`)  
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='權(quán)限規(guī)則表';

? ??? yii2?? rbac? ???? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!