So I have a login that has sysadmin rights on the db server. However, it's not able to access database objects under a custom schema that was created (eg. it cannot select from tables with [custom_schema].[table_name]). Do I need to explicitly grant permissions for this login to the custom schema even though it is part of the sysadmin server role? If that is the case, do I simply run the following if I want it to have db_owner rights to my custom schema?

GRANT TAKE CONTROL ON SCHEMA :: [custom_schema] TO [login];

Thank you in advance!


1 Answer 1


No, members of the Sysadmin role or the database owner role bypass the permission checking algorithm. So no matter what permission are granted or denied , they are able to always access the objects.

  • Exactly, that's what I thought too but apparently it isn't the case. There's no harm in me explicitly granting permissions, it's just weird and I wanted to confirm this phenomenon. And yes, I'm sure the tables in question don't also exist in the default dbo schema and the tables created under the custom_schema are present because I can see/access them with no problem.
    – Chinesinho
    Commented Jan 2, 2014 at 17:06
  • @Chinesinho if it's not working, please post an exact error message and also evidence that the user getting that error is in fact in the sysadmin role. Commented Jan 2, 2014 at 17:09
  • @AaronBertrand: The error is as follows - "SSIS Error Has Occurred: Microsoft.SqlServer.Dts.RunTime.TaskHost-1071610793 ADO_DST_[custom_schema.table_name] [3218] Failed to get properties of external columns. The table name you entered may not exist, or you do not have SELECT permission on the table object and an alternative attempt to get column properties through connection has failed. Detailed error messages are: Invalid object name [custom_schema].[table_name]. No column in"
    – Chinesinho
    Commented Jan 2, 2014 at 17:22
  • So how are you certain that your SSIS package is running in the context of a sysadmin account? Did you check> Commented Jan 2, 2014 at 17:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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