CODEWITHSUNDEEP
sql-serverazureazure-sql-database
fabian278
fabian278

Reputation: 115

How can I give access to a external user to my Azure database?

I've recently created a App Service + SQL in my Azure account and I want to give access to some external user, maybe using SQL authentication with username and password. I know I must allow this user IP, but I cannot find where I can create credentials or a new user for him.

I've tried creating a new login and user using SQL statements but I can't access master database.

Is what I'm trying to do possible?

Thanks

Upvotes: 0

Views: 1395

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89091

There's no need to grant users access to Master. Instead connect to the target database as an administrator and simply add the user using CREATE USER

CREATE USER SomeUserName WITH PASSWORD = 'somestrongpassword123'

See generally Controlling and granting database access

Upvotes: 4

Related Questions