Permissions Problem ADF


  • Hello

    I would like to have our ADF run by a user with just the needed permissions. All code that has to be executed was tested with the user, works fine.

    But, in the copy Action i'm getting a insufficient permissions error, but on this line of code (Suppose from ADf itself).

    IF NOT EXISTS (SEMECT * FROM sys.symmetric_keys where symmetric_key_id = 101) CRETAE MASTER KEY;

    This is quite a privilege needed by ADF ....

    Any suggestions ?

    Wednesday, September 5, 2018 5:39 PM


  • Hi, 

    This is the first T-SQL statement to start a Polybase load. It is used to ensure the master has been created and requires Control permission on the data warehouse.

    Thursday, September 6, 2018 11:15 AM

All replies