Azure SQL Data Warehouse permissions to create an External Table

Question

I have a user who needs to run a stored procedure. Within that stored procedure is a CREATE EXTERNAL TABLE statement. This statement runs flawlessly when executed by a high-permissioned user.

But when run by a low-permissioned user, the statement fails with the error:

Cannot find the object {table name} because it does not exist or you do not have permissions.

I have explicitly GRANTED the user the following permissions:

GRANT CREATE TABLE TO {user};
GRANT ALTER ANY SCHEMA to {user};
GRANT ALTER ANY EXTERNAL DATA SOURCE to {user};
GRANT ALTER ANY EXTERNAL FILE FORMAT to {user};

What have I missed?

Marc Jellinek · Accepted Answer · 2017-06-01 19:30:13Z

3

There was a DENY ALTER ANY SCHEMA in the mix. Found it, REVOKED it and was successful. Problem solved.

answered Jun 1, 2017 at 19:30

Marc Jellinek

5588 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

wBob Over a year ago

Feel free to mark that as the answer. Self-answers are useful for people arriving at the same issue.

Collectives™ on Stack Overflow

Azure SQL Data Warehouse permissions to create an External Table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related