hello jaime,
roles are always global... i don't think you can create roles that
exist just in one database...
you assign permissions to roles via the GRANT statement...
that's a little surprising, but definitely good to know!
so, if i understand you correctly, it does not matter which database i'm logged into when i create a role?
where (what database/table), then, are theses assignments stored?
i've clearly misunderstood how these work, i think.
thanks,
pres