Accessing backup information for none DBO's

• 
  If you want to allow users to view the backup history using the SQL Backup GUI, you need to grant them access to the SQL Server instance and also to the sqbutility extended stored procedure, but not necessarily the dbo role.
  
  E.g. for a Windows user named 'backupaudit':
  
  - create the new user in Windows
  - grant this user access to the SQL Server instance
  - grant this user access to the master database. You need not grant the dbo role, just the 'public' role is sufficient
  - grant this user rights to run the sqbutility extended stored procedure e.g.
  
  GRANT EXECUTE ON sqbutility TO backupaudit
  
  This user can now use the SQL Backup GUI to view the backup and restore history, but will not have rights to perform backups and restores.
  
  You might want to create a Windows user group instead and grant the SQL Server rights to this group, then add the individual users to this group, to simplify user management.

  petey March 20, 2007 02:34

  - 0 +
• 
  Thanks for that..

  Surinder March 20, 2007 05:11

  - 0 +
• 
  I have also had to give execute access to sqbStatus.
  
  Otherwise once in a while the GUI would complain about not having access to it and drop the connection to the server.

  Surinder March 21, 2007 05:13

  - 0 +

Add comment

Please sign in to leave a comment.