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.
Check the user is added to Users
NOTE: user has permission to SAM_TDD stream on QA environment.