1

I was asked to create an account to use Database Tuning Advisor. I red on technet but I don't understand which permission do I have to give.

I tried to login with this new user, but trying to list tables, I always get warning about there are no user tables available. If I give db_owner to the user the tables are listed.

Thanks for help.

Bye

2

From BOL : Permissions Required to Run Database Engine Tuning Advisor

After you install SQL Server, a user who is a member of the sysadmin fixed server role must launch Database Engine Tuning Advisor before anyone else. When the sysadmin user launches Database Engine Tuning Advisor that action initializes the application for use by others. After Database Engine Tuning Advisor is initialized, any user who is a member of the db_owner fixed database role can use it to tune tables on databases they own. For more information about initializing Database Engine Tuning Advisor.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.