Verifying Database Privileges

Follow these steps to verify the database privileges in the SQL Server.

  1. Log into the SQL Server with valid credentials.
  2. In Object Explorer, expand Security and Logins.
  3. If you have previously set up a user with the necessary database privileges:
    1. Right-click on the user's name and select Properties.
    2. Select Server Roles.
    3. Ensure that public and sysadmin have been selected.
  4. If you need to set up a user with database privileges:
    1. Right-click Logins > New Login.
    2. Type the login name of the user that is to be granted database privileges. Select the Windows authentication radio button.
    3. In the left pane, select Server Roles. Select the checkboxes as shown below, and click OK.