Why is it that whenever i try to provide a dynamic RoleGroup name through the following query the authentication won't works, It will always return access denied.
select Role, RoleGroup from Roles where PrincipalID=?"
whereas if i would provide a static RoleGroup name (Roles) it will work
select Role, 'Roles' from Roles where PrincipalID=?"
Can someone please help?
Thanks
regards,
Stephen