Database role access level issues in sql server.

If you create one login named as 'kumar' and map the login to the user 'kumar' in the 'test' database.
Let us see below scenario.
1.First i gave db_datareader role for that login 'kumar' ,then try to execute below queries.

Let us see what will happen.


To resolve above error ,what role needs to give for 'kumar' login?
db_datawriter.

To resolve above error ,what role needs to give for 'kumar' login?
db_ddladmin and to resolve below by giving db_backupoperator

Comments

Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)