Sharing dataset with other user does not show Query Editor

I have created a dataset using custom SQL query with SPICE and shared with other user in my company. I have set the role as owner. But the other user is not able to see the query editor in dataset.

DO we need to enable any settings to see the query editor?

In the permissions of the dataset, is the other user setup as “co-owner” or “user”?

It has been set as Owner