SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[rolePrivileges](
	[roleId] [int] NULL,
	[roleFields] [varchar](500) NULL
) ON [PRIMARY]
INSERT [dbo].[rolePrivileges] ([roleId], [roleFields]) VALUES (1, N'dataField1,dataField2,dataField3,dataField4')
INSERT [dbo].[rolePrivileges] ([roleId], [roleFields]) VALUES (2, N'dataField1,dataField2')
INSERT [dbo].[rolePrivileges] ([roleId], [roleFields]) VALUES (3, N'dataField1,dataField3,dataField4')
3 rows affected

select * from rolePrivileges


roleId
roleFields


1
dataField1,dataField2,dataField3,dataField4

2
dataField1,dataField2

3
dataField1,dataField3,dataField4


declare	
@role tinyint=3,
@dataField1 [varchar](10)='aa',
@dataField2 [varchar](10)='bb',
@dataField3 [varchar](10)='cc',
@dataField4 [varchar](10)='dd'

--update myTable

--datas
select 
dataField1=@dataField1
,dataField2=@dataField2
,dataField3=@dataField3
,dataField4=@dataField4
--count permission
select f.* from rolePrivileges r 
cross apply string_split(r.roleFields,',') as f 
  where r.roleId=@role  and f.value='datafield3'


dataField1
dataField2
dataField3
dataField4


aa
bb
cc
dd




value


dataField3

roleId	roleFields
1	dataField1,dataField2,dataField3,dataField4
2	dataField1,dataField2
3	dataField1,dataField3,dataField4