Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

db_owner & dms$system.UserQueries

Is it possible to access the db_owner role of a datamart database through SSMS? Even as an admin_user there is no permissions to grant, no extended events and some restricted tables 

 

Additionally is it possible to query dms$system.UserQueries? the schema seems to be restricted by default

access
Datamart
SQL Endpoint

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi Anonymous 

     

    It seems difficult. I connected to a datamart with SSMS and saw something like below. I'm not able to modify the properties as we usually do when connecting to an on-premises database server. 

     

    Best Regards,
    Community Support Team _ Jing