Datamart - SQL database capabilities

[cmeu]

I am checking out the datamart preview feature. This is really exciting! But I have some questions..

Is it possible to provision a user(s) as member of the db_owner role?

Can a user create stored procedures, schemas, tables, users, etc.?

Can we write data directly to datamart db?

Can datamart be used as target for power app insert/update operations?

[peteroest1978]

I have done the same as what have been written here - assigned a user the role viewer (that has the role public in the datbase) in my workspace and then tried to add the role public to the db_owner role. I wrote:

EXEC sp_addrolemember 'db_owner', 'public'

The answer I get is: Cannot alter the role 'db_owner', because it does not exist or you do not have permission.

Why does this happen? db_owner exist in my database and I am an admin_user.

[v-henryk-mstf]

Hi @cmeu ,

Users can be configured as members of the db_owner role

There can be some limitations to creating.

Administrators can manage the following functions in the admin portal, which include writing data to the Datamart database

There is no more information about the features of the power app yet, but after all, it is a PREVIEW feature and may be introduced in a subsequent update or release with similar features.

For more details, you can read related document as below:

Administration of datamarts (preview) - Power BI | Microsoft Docs

Analyzing datamarts (preview) - Power BI | Microsoft Docs

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cmeu]

Thanks for the reply -
- db_owner is not the same as "admin_user" - db_owner has full permissions within the database
- I am interested in DDL and DML, but not within the visual editor (I am using external SQL IDE to connect to SQL Server service)
- I saw about the auditing available in the admin center - but I believe this is just a report that indicates the quantity of operations being performed, by type? This doesn't explain how to perform INSERT or UPDATE

I can certainly appreciate this is in preview and we don't know the full details yet

Thanks for your response!