Snowflake connector - Ownership confusion

Identity Security Cloud (ISC) ISC Discussion and Questions
, ,
1

Hello,
We are getting sailpoint integrated with snowflake saas connector. I have a question on the ownership documentation provided by sailpoint

In the document:
“To grant ownership permissions, use the following command:
GRANT OWNERSHIP ON USER “UserName” TO ROLE “Rolename”;
Where UserName refers to the name of the user that you are modifying.”

I am not fully following what sailpoint wants us to do.

Apply the grant to which user and role or all users to the sailpoint role or a specific user to a specific role?

2

Hi Shajedul,

The UserName and Rolename that is referred to in that documentation tab can be found in the ‘Required Permissions’ section of the documentation - Required Permissions

This section lists out steps to setup the Snowflake admin account with the required permissions.

Thanks,

Liam

3

Hi @liamkokeeffe It asks to create a user and grant the appropriate permissions using the snowflake account admin role.

In the documentation, it mentions this:
“GRANT OWNERSHIP ON USER “UserName” TO ROLE “Rolename”;”

Does it mean to provide ownership to the newly created user? and also which role? sysadmin is the one they asked to provide.

4

In the link that I sent there are instructions to create a user (they reference it as UserName) and to create a role (they reference it as Rolename).

You would follow those instructions and create a new user and role. Then I believe you would grant ownership of that role you created to the new admin user you created.

Let me know if that works!

Thanks,

Liam

1 Like
5

Ah yes, i asked the system owner to follow that process. Thank you!