Views

[misuk11]

can anyone tell me how I grant select access to specific roles for a view ? With a table i just right click, edit and add the role, a view doesnt have an equivalent mechanism.

 

[Marco Kalter]

For a view this is indeed not possible from a GUI. You can edit the Role(s) though, and add the view privileges from there.

It would be useful to have this capability from the context of the view, but currently this is not possible.