Offline
Kod:
----------------------------------------------------------------------------------------
---Buraya Elleme
USE SRO_VT_ACCOUNT
delete from _SecurityDescriptionGroupAssign where nGroupID = '10'
INSERT INTO _SecurityDescriptionGroupAssign (nGroupID, nDescriptionID)VALUES ('10', '14')
INSERT INTO _SecurityDescriptionGroupAssign (nGroupID, nDescriptionID)VALUES ('10', '28')
INSERT INTO _SecurityDescriptionGroupAssign (nGroupID, nDescriptionID)VALUES ('10', '29')
---Buraya Elleme
-----------------------------------------------------------------------------------------
USE SRO_VT_ACCOUNT
-----------------------------
DECLARE @StrUserID varchar(25)
-----------------------------
SET @StrUserID = 'GA Yapılacak Kullanıcı' -- Giriş ID
-----------------------------
update TB_User set GMrank = 1 where StrUserID = @StrUserID
update TB_User set sec_content = 10 where StrUserID = @StrUserID
update TB_User set sec_primary = 10 where StrUserID = @StrUserID