I understand there is a way now to use User.Identity.IsInRole to establish certain permissions for certain users. I am trying to understand how to use this and seem to be hitting a brick wall.
My app is set up to use windows integrated security. The SQL Server db allows everyone in my domain access to the database. Then I have several db roles that allow only certain users to perform certain tasks.
I have a few items on my forms that I want to show ONLY if the user is in the specific SQL server group. However, it seems that I am only checking windows domain groups and not the groups from SQL. Is there anyway to use Windows Integrated authentication AND SQL Server groups?
Thank you so much.
Eva
My app is set up to use windows integrated security. The SQL Server db allows everyone in my domain access to the database. Then I have several db roles that allow only certain users to perform certain tasks.
I have a few items on my forms that I want to show ONLY if the user is in the specific SQL server group. However, it seems that I am only checking windows domain groups and not the groups from SQL. Is there anyway to use Windows Integrated authentication AND SQL Server groups?
Thank you so much.
Eva