what is the least privilege needed for data factory
up vote
1
down vote
favorite
I am copying data from on-premise to azure data warehouse. I have set up SQL authentication account for data factory with db_writer, db_reader roles and ddladmin roles for that account. When I execute the job it fails, if i assign db_owner to the account then it succeeds. What is the least privilege we should give to data factory account?
i am not convinced db_owner is the right level.
Thanks in advance
azure permissions azure-data-factory-2 asked Oct 30 at 15:33
Anbarasan Dhanushkodi
164
add a comment |
up vote
1
down vote
favorite
I am copying data from on-premise to azure data warehouse. I have set up SQL authentication account for data factory with db_writer, db_reader roles and ddladmin roles for that account. When I execute the job it fails, if i assign db_owner to the account then it succeeds. What is the least privilege we should give to data factory account?
i am not convinced db_owner is the right level.
Thanks in advance
azure permissions azure-data-factory-2 asked Oct 30 at 15:33
Anbarasan Dhanushkodi
164
This link may be helpful:docs.microsoft.com/en-us/sql/relational-databases/security/…
– Joy Wang
Oct 31 at 1:57
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I am copying data from on-premise to azure data warehouse. I have set up SQL authentication account for data factory with db_writer, db_reader roles and ddladmin roles for that account. When I execute the job it fails, if i assign db_owner to the account then it succeeds. What is the least privilege we should give to data factory account?
i am not convinced db_owner is the right level.
Thanks in advance
azure permissions azure-data-factory-2 asked Oct 30 at 15:33
Anbarasan Dhanushkodi
164
I am copying data from on-premise to azure data warehouse. I have set up SQL authentication account for data factory with db_writer, db_reader roles and ddladmin roles for that account. When I execute the job it fails, if i assign db_owner to the account then it succeeds. What is the least privilege we should give to data factory account?
i am not convinced db_owner is the right level.
Thanks in advance
azure permissions azure-data-factory-2 azure permissions azure-data-factory-2 asked Oct 30 at 15:33
Anbarasan Dhanushkodi
164
asked Oct 30 at 15:33
Anbarasan Dhanushkodi
164
asked Oct 30 at 15:33
Anbarasan Dhanushkodi
164
asked Oct 30 at 15:33
Anbarasan Dhanushkodi
164
asked Oct 30 at 15:33
Anbarasan Dhanushkodi
164
164
This link may be helpful:docs.microsoft.com/en-us/sql/relational-databases/security/…
– Joy Wang
Oct 31 at 1:57
add a comment |
This link may be helpful:docs.microsoft.com/en-us/sql/relational-databases/security/…
– Joy Wang
Oct 31 at 1:57
This link may be helpful:docs.microsoft.com/en-us/sql/relational-databases/security/…
– Joy Wang
Oct 31 at 1:57
This link may be helpful:docs.microsoft.com/en-us/sql/relational-databases/security/…
– Joy Wang
Oct 31 at 1:57
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53067872%2fwhat-is-the-least-privilege-needed-for-data-factory%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
This link may be helpful:docs.microsoft.com/en-us/sql/relational-databases/security/…
– Joy Wang
Oct 31 at 1:57