Dataset Permission to not edit custom sql but see details

[hoyeon]

Is there a way to specify dataset permissions for users/groups to not edit the custom sql but view other properties?

For instance, I would like to let users to view Summary, Refresh, Usage, Permissions tabs on the dataset page, but want to prevent them from editing those properties or viewing/editing the custom sql.

I tested with different permissions sets when creating a dataset by API.

A user’s permission set

"quicksight:DescribeDataSet",
"quicksight:DescribeDataSetPermissions",
"quicksight:PassDataSet",
"quicksight:UpdateDataSet",
"quicksight:DeleteDataSet",
"quicksight:DescribeIngestion",
"quicksight:ListIngestions",
"quicksight:CreateIngestion",
"quicksight:CancelIngestion",
"quicksight:UpdateDataSetPermissions"

B user’s permission set

"quicksight:DescribeDataSet",
"quicksight:DescribeDataSetPermissions",
"quicksight:PassDataSet",
"quicksight:DescribeIngestion",
"quicksight:ListIngestions",
"quicksight:CreateIngestion",
"quicksight:CancelIngestion"

A user can see all details and edit/update settings for the dataset.
B user only can see SPICE size and Use in Analysis button from the dataset page.

[Xclipse]

Hi @hoyeon, hope these posts help:

Permissions to Edit Custom SQL

@neelay What is the quicksight management interface?

Is it possible to make authors unable to edit/save custom SQL of a dataset(but still able to view it and use)?

Hi @David_Wong - Just thinking, can we also have an approach to see the custom sql logic without having edit option. Possibly when a user just move the mouse so kind of pop up to see the logic. Not sure whether it will be a useful feature or not, please advise. If it is going to helpful from developer experience prospective, we can always request QS team to add this as feature request. Regards - Sanjeeb

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community!