Privileges granted by role or direct
I wan to know why I get an error at the compilation time of a procedure if it access a sequence in which I got enough privileges through a role. The error messages is “Insufficient privileges” when the procedure references the sequence. But when I grant the same privileges directly I don’t get this error.
anyone knows why this happens?
Thanks,
Victor