Unable to create a role when using ACCOUNTADMIN or SYSADMIN in Snowflake

0
votes

I am getting the error "SQL access control error: Insufficient privileges to operate on account 'XXXXXX'" when I try to create a role in Snowflake in order to get it connected to Segment.

I am following the Segment documentation here: https://segment.com/docs/connections/warehouses/catalog/snowflake/

And I am getting stuck when I run the command "CREATE ROLE "SEGMENT";"

Any help in how to get around this would be great. I am currently on the trial and was able to successfully create the data warehouse and database as per the segment instructions.

1
snowflake-cloud-data-platformsnowflake-schemasnowflake-task
Are you explicitly setting your role as ACCOUNTADMIN (i.e use role accountadmin;) before trying this? Do you have access to the SECURITYADMIN role and if so could you try creating the role with that? – Mike Donovan

1 Answers

1
votes

Thanks to Greg in the comments: "An easy way to remember it is that the upper right role is for UI actions, while the lower one sets the context for the worksheet"

1) while I had the correct profile up here

2) once I clicked this

3) I did not have the right profile in here

After switching to ACCOUNTADMIN in 3) I was able to create the role.

screenshot of how I fixed it