14 lines
1.0 KiB
Transact-SQL
14 lines
1.0 KiB
Transact-SQL
Use [EnVisage]
|
||
|
||
UPDATE dbo.[Security] SET SecurityObject = 'AccessToOtherResources' WHERE SecurityObject = 'NonProjectTimeFullAccess'
|
||
GO
|
||
|
||
INSERT INTO dbo.[Security] (PrincipalId, [Read], [Write], SecurityObject)
|
||
SELECT A.PrincipalId, A.[Read], A.[Write], 'RD_ResourceNonProjectTime' FROM dbo.[Security] A
|
||
WHERE A.SecurityObject = 'AccessToOtherResources' AND
|
||
NOT EXISTS(
|
||
SELECT B.* FROM dbo.[Security] B
|
||
WHERE (B.PrincipalId = A.PrincipalId) AND (B.SecurityObject = 'RD_ResourceNonProjectTime')
|
||
)
|
||
GO
|