Creating a Microsoft SQL Server User and Granting Permissions

Create a Microsoft SQL Server user named “ra_user” with the password “sybase,” and grant permissions to the user.

use master;

create login ra_user;

use <primary_database>;

create user ra_user for login ra_user;

EXEC sp_addsrvrolemember 'ra_user','sysadmin';