Adding User To SAM

Add data to SQL DB

Connect to database QLIK_UserDirectory and execute below querries

INSERT INTO [QLIK_UserDirectory].[dbo].[qlikuser] ([userid], [name]) VALUES
('qauser1', 'QA User Name1')

INSERT INTO [QLIK_UserDirectory].[dbo].[qlikuserattribute] ([userid], [type],[value]) VALUES
('qauser1', 'email', 'hemangi+qauser1@ebiexperts.com')

select * from [QLIK_UserDirectory].[dbo].[qlikuser]
where userid ='qauser1'

select * from [QLIK_UserDirectory].[dbo].[qlikuserattribute]
where userid ='qauser1'

Sync on QMC

Go to QMC -> home
manage resources -> user directory connections
select the record with Name =SAM_SqlServer and click on sync now.

Open

Check the user is added to Users

Open

NOTE: user has permission to SAM_TDD stream on QA environment.