which sort of Privelleges needed for these type of Logins in SQL server at Database level

• naga.rohitkumar

  SSCertifiable

  Points: 5557

  More actions

  December 1, 2014 at 1:11 am

  #298999

  Hi alll,

  Which sort of Privileges needed for these type of Logins in SQL server at Database level

  Rather than giving Sysadmin to a Login and Db_owner at database roles i want to restrict the permissions as per the Requirement.

  1. For running Scheduled Jobs [what should we assign ]

  2. For using only backup restoration

  3. For using only a particular database with full permissions on all schema's

  4. For sending only database mails if any configured.. ]

  5. For using only to access Reports..

  6. To view only error logs in sqlserver.

  Thanks

  Naga.Rohitkumar

  Thanks
  Naga.Rohitkumar