I have the following problem: I have my table access
In this table I relate the Role with a Module and the Permission it has.
What I want is to create a view that returns the data to me in the following way:
View returning the data.
I want to group by Modules and return in 3 new columns 1 if you have that permission or 0 if you do not have it.
Try to do it this way but do not group me by modules
SELECT DISTINCT modulo, case when permiso LIKE 'A' then 1 else 0 end AS p1, case when permiso LIKE 'C' then 1 else 0 end AS p2, case when permiso LIKE 'M' then 1 else 0 end AS p3 from acceso group by modulo, permiso
I appreciate your help.