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