54 lines
1.1 KiB
Transact-SQL
54 lines
1.1 KiB
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 @name nvarchar(255) = 'Ott'
|
|
DECLARE @firstname nvarchar(255) = 'Stefan'
|
|
DECLARE @title varchar(50) = 'Dr.'
|
|
DECLARE @gender varchar(1) = 'm'
|
|
DECLARE @email varchar(255)= 'info@processweb.de'
|
|
DECLARE @mobile varchar(50) = ''
|
|
DECLARE @password nvarchar(20) = CAST([dbo].[ocms_fn_generatePassword] (8, 0, 1, 1) as nvarchar(20))
|
|
|
|
|
|
|
|
-- TODO: Set parameter values here.
|
|
|
|
EXECUTE @RC = [dbo].[fis_admin_createUserAccount]
|
|
@name
|
|
,@firstname
|
|
,@title
|
|
,@gender
|
|
,@email
|
|
,@mobile
|
|
,@password
|
|
,@enc_key;
|
|
|
|
|
|
|
|
--DECLARE @authaccount varchar(5) = 'J5KL8'
|
|
--DECLARE @useraccount_id varchar(5) = 'J5KL8'
|
|
--SET @name = null
|
|
--SET @firstname = null
|
|
--SET @password = null
|
|
|
|
---- TODO: Set parameter values here.
|
|
|
|
--EXECUTE [dbo].[fis_admin_setUserAccount]
|
|
-- @authaccount
|
|
-- ,@useraccount_id
|
|
-- ,@name
|
|
-- ,@firstname
|
|
-- ,@title
|
|
-- ,@gender
|
|
-- ,@email
|
|
-- ,@mobile
|
|
-- ,@password
|
|
-- ,@enc_key
|
|
--GO
|
|
|
|
|
|
|
|
|
|
CLOSE SYMMETRIC KEY [fuchs_enc_1] |