Thanks ramses2nd;

The add and drop role will work but I need to switch the roles fairly often and hope there is another technique.

I had used a technique in antoher database...