Question: I moved a database from SQL Server 2012 to Azure. I don't want to use the user `master`, so I created a user `test`. This is what I did for database XXX on Azure:

```
create user test from login test with default_schema=[dbo]
exec sp_addrolemember 'db_owner','test'

```

I checked, and the database objects I am interested in are all in the schema `dbo`. The table `Users` is in the schema `dbo`.

The connection string in my web project has `test` as the login. It produces the error message:

```
The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'

```

What does the error message mean and what can I do to let user `test` access the database XXX?

Answer: 
I think the problem is with the user having **deny privileges**. This error comes when the user which you have created does not have the sufficient privileges to access your tables in the database. Do grant the privilege to the user in order to get what you want. 

**[GRANT](https://learn.microsoft.com/en-us/sql/t-sql/statements/grant-object-permissions-transact-sql)** the user specific permissions such as SELECT, INSERT, UPDATE and DELETE on tables in that database.
Check space of your database.this error comes when space increased compare to space given to database.