# Cdata Sync SQL Server Permissions for data loads **URL:** \ **Category:** CData Sync\ **Tags:** question, permissions, cdata-sync, sql-server\ **Created:** [January 9, 2025, 5:03pm UTC](https://community.cdata.com/t/cdata-sync-sql-server-permissions-for-data-loads/991 "2025-01-09T17:03:50Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Marcus\_S](https://avatars.discourse-cdn.com/v4/letter/m/e274bd/32.png) [@Marcus\_S](https://community.cdata.com/u/Marcus_S)\ **Post date:** [January 9, 2025, 5:03pm UTC](https://community.cdata.com/t/cdata-sync-sql-server-permissions-for-data-loads/991/1 "2025-01-09T17:03:51Z")
Hey All, I am trying to adhere to the principle of least permissions. I created a SQL Server Authenticated Login for cdata to use as a service account to SQL Server. I’m not sure what permissions it needs at the database level though? I wasn’t able to find any documentation on the site about minimum permissions cdata sync service account for SQL Server would need. I allow the cdata sync service account to drop and create tables. My guess is that I only need to add the cdata sync service account user to the following database level roles in my data lake. ddl\_admin db\_datareader db\_datawriter What I am not sure about is whether or not Cdata Sync Service Account needs to have permissions to create Schemas. Thanks ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [January 9, 2025, 10:31pm UTC](https://community.cdata.com/t/cdata-sync-sql-server-permissions-for-data-loads/991/2 "2025-01-09T22:31:22Z")
​ @Marcus_S We do not have any specific documentation for minimum permissions required for the SQL Server connection to be used in Sync, unfortunately. However, to address your query CData Sync is not intended to create schemas which means the Service Account that you will be using  for your SQL Server connection in CData Sync does not need to have CREATE SCHEMA permissions. If you have any other questions you can reach out to the CData Support team at [support@cdata.com](mailto:support@cdata.com) and one of our Sync support specialists will further assist you.