I am trying to create a new role to add to Analysts to add further privileges beyond the normal Analyst role. For example, I want to designate some analysts as "Sub Admins" who can create other Analysts.
When I create a new analyst role, it comes with a bunch of privileges already enabled. Is there a way to create a role with no privilege settings (so will not grant or deny anything), then grant additional privileges to that role, and add that role to analyst objects who would then also have the analyst role?
If so, how do I do the first part (create the blank-slate role)?