Post reply

Easily grant access to a single Azure sql database-view

  • May 15, 2018 at 7:12 am

    #345202

    Hi
    how can I easily grant access to a single Azure sql database-view (without creating an AD account??); Ideal would be access via url ...OR copy table to ...whatever ...

    thanks
    Nicole :ermm:

  • May 16, 2018 at 7:59 am

    #1990663

    No matter what, you have to query the database (unless you export the data), so there has to be either an AD login or SQL login that can run the query to retrieve information. You can create a web page that has access to the data through that login and then expose that URL to other people. Same thing if you want to export the data. It has to be exported to something that you can define access to. Although, you can probably export it all to azure storage and the expose that to the world through a URL (not my first, or fifteenth, choice, but it'll work).

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply