How to create a login, user, and give rights over database in SQL Azure?

Question

I am trying to give permissions to a user I just created and has a login associated logged into my master.

I was not able to give any permissions since it says you do not have permissions to do this.

I gave myself dbowner rights in the master but still.

Any help?

Might it be that the database I created does not have the schema dbo?

Shahin Dohan · Accepted Answer · 2013-04-11 15:33:56Z

1

UPDATE:
I thought you said the user you added didn't have any permissions, my bad! Well the answer still might be helpful :-)

I'm not an SQL expert so this may not answer your question, but I had to do something like this today and listing my steps might help.

You can use a graphical tool like Azure User Management Console (AUMC) if you want to add users without having to write a bunch of SQL queries.

Connect to your server, go to Logins and create a new login (if you want to give server access as well), then go to Users, select your database, create a new user, then here you can link the user to the login you just created and give database permissions.

edited Apr 11, 2013 at 15:33

answered Apr 11, 2013 at 15:27

Shahin Dohan

7,0024 gold badges47 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Muhammad Omar ElShourbagy · Accepted Answer · 2013-04-11 15:32:04Z

1

Here is the documentation on granting users/logins permissions:

http://blogs.msdn.com/b/sqlazure/archive/2010/06/21/10028038.aspx

EXEC sp_addrolemember 'db_datareader', 'readonlyuser';

answered Apr 11, 2013 at 15:32

Muhammad Omar ElShourbagy

7,1182 gold badges34 silver badges51 bronze badges

Collectives™ on Stack Overflow

How to create a login, user, and give rights over database in SQL Azure?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related