23 lines
548 B
Transact-SQL
23 lines
548 B
Transact-SQL
USE [site_fuchs]
|
|
GO
|
|
OPEN SYMMETRIC KEY [fuchs_enc_1] DECRYPTION BY PASSWORD = N'+0&PY+6iyjlKyQ';DECLARE @enc_key uniqueidentifier = key_guid('fuchs_enc_1');
|
|
|
|
DECLARE @RC int
|
|
DECLARE @authaccount varchar(5) = 'J5KL8'
|
|
DECLARE @usergroup_id varchar(5) = NULL
|
|
DECLARE @name nvarchar(255) = 'Lesende'
|
|
|
|
-- TODO: Set parameter values here.
|
|
|
|
EXECUTE @RC = [dbo].[fis_admin_setUserGroup]
|
|
@authaccount
|
|
,@usergroup_id
|
|
,@name
|
|
,@enc_key
|
|
;
|
|
|
|
|
|
SELECT CAST(DECRYPTBYKEY([name_enc]) as nvarchar(255)) from fis_usergroups
|
|
|
|
|
|
CLOSE SYMMETRIC KEY [fuchs_enc_1] |