1, according to the user read the relevant permissions
CREATE PROCEDURE [dbo]. [Getroleaction]
@UserGUID uniqueidentifier,
@DepartmentGUID uniqueidentifier
As
BEGIN
IF @UserGUID = ' f425ba38-df44-45d0-a9bb-f5c904bfee1c '
BEGIN
SELECT A.guid,a.controllername,a.actionname from Action a
END
ELSE
BEGIN
SELECT DISTINCT A.guid,a.controllername,a.actionname from Action a
INNER JOIN role_action ra on RA. Actionguid=a.guid
INNER JOIN Role R on R.guid=ra. Roleguid
Left joins user_role ur on ur. Roleguid=r.guid
Left JOIN Department_role Dr. on Dr. Roleguid=r.guid
WHERE [email protected] OR [email protected]
END
END
2. Get menu permission list according to user
CREATE PROCEDURE [dbo]. [Getrolemenu]
@UserGUID uniqueidentifier,
@DepartmentGUID uniqueidentifier
As
BEGIN
IF @UserGUID = ' f425ba38-df44-45d0-a9bb-f5c904bfee1c '
BEGIN
SELECT M.guid,m.parentguid,m.displayname,m.iconclass,m.requesturl,m.rootlevel,m.orderindex from Menu m
END
ELSE
BEGIN
SELECT DISTINCT M.guid,m.parentguid,m.displayname,m.iconclass,m.requesturl,m.rootlevel,m.orderindex from Menu m
INNER JOIN Role_menu RM on RM. Menuguid=m.guid
INNER JOIN Role R on R.guid=rm. Roleguid
Left joins user_role ur on ur. Roleguid=r.guid
Left JOIN Department_role Dr. on Dr. Roleguid=r.guid
WHERE [email protected] OR [email protected]
END
END
Database stored procedures in Rights management