ERP permission update

xiaoxiao2021-03-06  73

INSERT INTO Permissions _ Name Table Values ​​(8800000, 'actual receivables',' act_realrcv ', 0) INSERT INTO Permissions _ name table VALUES (8800001,' actual payment ", 'act_realpay', 0) INSERT INTO permission Table VALUES (8800002, 'Purchasing Case Price ",' BuybillPrice ', 0) INSERT INTO Permissions _ Name Table Values ​​(8800003,' Sales Case Price", 'SaleBillPrice', 0)

Delete from privileges _ name table where permission number = 132100 delete from privilege _ name table where permission number = 132200 delete from privileges _ name table where permission number = 9000000 delete from privileges _ name table where permission number = 9000001 Delete FROM privileges _ name table Where permission number = 9000002 delete from privilege_name table where permission number = 9000003

Delete from dbo. Permissions _ 分明 细 细 WHERE Permissions Number Not in (SELECT Permissions No. FROM Permissions _ Name Table)

SELECT * FROM permissions _ name table Order BY permission number

转载请注明原文地址:https://www.9cbs.com/read-120492.html

New Post(0)