Search code examples
vertica

Merge roles in vertica

Do you know if there is a smart way to merge different roles into one single role in HP vertica database? I mean, I have 3 roles with different grants in vertica, and I need to merge those 3 into 1. Is there a smart way to do it? Thanks.

Solution

  • Why not this?

    SQL>create role one;
role created
SQL>create role two;
role created
SQL>create role three;
role created
SQL>create role allofthem;
role created
SQL>grant one,two,three to allofthem; 
grant  succeeded

    cheers ...