Notifications
Announcements
No record found.
Hi
When BYOD is executed, a table will be created in Azure SQL DB, but the schema is dbo.how can I specify something other than dbo?If can specify it, please tell me how to do it.
Please, some advises.
Thanks
Hi Akaishi,
As far as know dbo is only supported. But you can try to change the default schema for the account used in the BYOD connection string in Azure SQL.
What is the purpose of changing schema? If you want to restrict access by schemas you can create SQL views on top of the staging table in another schema.
Hi Sergei,
The purpose is to limit access privileges.
I want to add a schema to BYOD and create two the same tables.
For example,dbo.TestStaging, abc.TestStaging.
Azure SQL Database is only support DBO?
You can create new schemas in Azure SQL DB, but you should keep in my that dbo is reserved for BYOD integration. Or do you want to use the same DB for several F&O instances?
Hi Sergei
The purpose of the question was to find out how BYOD controls access to data linked to Azure SQL DB.I think that control by DB schema is common as access control to data, but I asked because I could not find a D365 standard function that specifies DB schema in BYOD.If It can not specify the DB schema with the D365 standard function and the default is dbo, I think that it is better to control access with the schema to View as your advised.In addition, we assume only one use of F & O that you asked.
Thanks.
Sergei,
Are you aware of another way to store data from 2 different env. in the same DB?
Are you saying that we have no choice and the export always goes out to the dbo schema?
Thank you.
Hey, you can set up the BYOD connection string with a DB login that has a different default schema than dbo.
If you're looking to export data from 2 env. to the same DB:
community.dynamics.com/.../1247385
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 467 Super User 2025 Season 2
Martin Dráb 420 Most Valuable Professional
BillurSamdancioglu 241 Most Valuable Professional
