Azure logins

  • Senchi

    Ten Centuries

    Points: 1074

    There is no forum for Microsoft Azure (It's 9 years we are waiting. Hello Steve !), so I'll post it here.
    I want to move 3 databases (Company1,Company2,Company3) from SQL Server 2014 to a single database on the Azure.
    So I want to have just 3 logins to that one  database.Example :
    Username : Company1
    Password : 123

    Username : Company2
    Password : 345
    ....
    So, how do I add database role and users to a specific company?

  • Sue_H

    SSC Guru

    Points: 89721

    Senchi - Tuesday, August 7, 2018 3:39 AM

    There is no forum for Microsoft Azure (It's 9 years we are waiting. Hello Steve !), so I'll post it here.
    I want to move 3 databases (Company1,Company2,Company3) from SQL Server 2014 to a single database on the Azure.
    So I want to have just 3 logins to that one  database.Example :
    Username : Company1
    Password : 123

    Username : Company2
    Password : 345
    ....
    So, how do I add database role and users to a specific company?

    There are a few Azure related forums if you check the Cloud Computing section:
    Cloud Computing

    How to address the security depends on how you are combining the three databases. How are you delineating the different companies in the one database?
    If you haven't yet, one option would be different schemas for each company.

    Sue

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

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