Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Datamart - SQL database capabilities

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?

General Comment

3 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    4 years ago

    Hi Anonymous ,

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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!

  • peteroest1978's avatar
    peteroest1978
    Regular Visitor
    3 years ago

    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.