MohammadM.15776 (Customer) asked a question.
Pushing multiple groups having same users to snowflake to get custom roles assigned to same users
I am trying to push multiple groups having same users to snowflake so that the users can have multiple roles that are created by pushing groups to snowflake. For Example I need same user to have two different roles like admin and analyst which are roles that are created by pushing groups to snowflake. Now what is happening is by default users are assigned only one of the group role and rest are not assigned. Is there any way to accomplish this?
Thanks in advance
Hi @MohammadM.15776 (Customer) , Thank you for reaching out to the Okta Community!
I've been looking into this but it seems that the Provisioning part was built by the service provider.
There seem to be some limitations around role management:
" Okta and the OKTA_PROVISIONER custom role in Snowflake cannot manage manually created roles in Snowflake. "
" Existing Snowflake roles cannot be brought under Okta’s management through transfer of ownership. Only new roles can be created through Okta."
My advice would be to discuss your use case with Snowflake Support as well.
If my answer helped, remember to mark it as best to increase its visibility for other members of the Okta Community who might have the same questions as you.
Hope my answer helps!
--------------------------------
The Okta Community November newsletter is here. Get product updates and see our top contributing members.