> Considering the following piece of code:
>
[quoted text clipped - 14 lines]
>
> Any help would be great! Thanks in advance.
I may be overlooking some detail, but "AS hruser" cannot be right...
This clause can be used by a DBA to grant a privilege as if it was granted by
the specified user..
So, you can't be granting a role to user hruser, as if it was granted by the
same user..
Nevertheless, the error messages doesn't seem correct. It's not a syntax error,
but an incongruence... something that can't be done...
"with grant option" will allow hruser to grant this role to others...
It seems this should be enough for your purposes...(?)
Hope this helps. If it's not enough or you find something wrong, I'll test it
(I didn't :) )
Regards.

Signature
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...