Cannot grant 'references' to a role - why not?
It is possible to grant create table to a role and then that role can create constraints on that table. 'References' is simply another kind of restraint, but for some reason it is not grantable to a role. Perhaps there is a rationale underlying why this is so that I do not know of, I would appreciate if anybody could direct me to a resource explaining it. Also, are there any other specific privileges not grantable to a role?