All,
I have two password-protected roles.
I need to activate more than 1 role at a time.
Each time I set a role the previous role goes away.
How can I get both roles to stay active?
Thanks,
Kathy
Printable View
All,
I have two password-protected roles.
I need to activate more than 1 role at a time.
Each time I set a role the previous role goes away.
How can I get both roles to stay active?
Thanks,
Kathy
You need to activate both together
SET ROLE role1 IDENTIFIED BY p1, role2 IDENTIFIED BY p2;