1.开发人员在设计和实现系统时,关联资源和操作,并 创造权限;2.管理员可以为用户分配权限;3.用户使用权限。 create table Users( ID int identity( 1 , 1 ) primary key, UserName varchar( 16 ), Password binary( 16 ));create table Roles( ID int identity( 1 , 1 ) primary key, Name nvarchar( 10 ));create table Permissions( ID int identity( 1 , 1 ) primary key, Name nvarchar( 10 ));create table UserRole( ID int identity( 1 , 1 ) primary key, UserID int foreign key references Users(ID), RoleID int foreign key references Roles(ID));create table RolePermission( ID int identity( 1 , 1 ) primary key, RoleID int foreign key references Roles(ID), PermissionID int foreign key references Permissions(ID), Allowed smallint default ( 0 ))