Set database permissions in SQL Server Management Studio
⟩
⟩ Set database permissions in SQL Server Management Studio

Set database permissions in
SQL Server
 Management Studio

Set database permissions for
SQL Server
.
To set database permissions in
SQL Server
 Management Studio
  1. Open
    SQL Server
     Management Studio.
  2. In the
    Server
    tree in the Object Explorer, right-click
    Logins
    and select
    New Login
    .
  3. Create a username by using any name or password.
  4. Assign the Server role
    bulkadmin
    .
  5. In the
    Databases
    tree, right-click
    Security
    >
    Users
    .
  6. Select the newly created username and assign these roles:
    • db_datareader
    • db_datawriter
    • ddadmin
  7. Exit
    SQL Server
     Management Studio.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.
Normal