Search <book_title>...

NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published: 2024-09-30

Product(s): NetBackup & Alta Data Protection (10.5)

RBAC roles for the SQL Server administrator

NetBackup enables control over which users can access which SQL Server assets using Role Based Access Control (RBAC). You can grant RBAC access globally (to all SQL Server assets) or to specific databases, instances, or availability groups.

The Default Microsoft SQL Server Administrator role has access to all SQL Server assets (global). With this role the administrator can also manage credentials for instances and availability group replicas. (These credentials are managed on the Instances tab in Workloads > Microsoft SQL Server.)

In addition, you may need other custom roles to give additional access to your SQL Server administrators.

A role that is restricted to an individual instance, database, or availability group.
A role that gives specific privileges to manage the host properties for SQL Server clients.
A role for a non-SQL Server administrator.

Note the following:

To create an RBAC role, you must have the RBAC Administrator role or the permissions to create roles.
Contact your NetBackup administrator for assistance with creating roles and adding users to roles.

For information on the RBAC permissions and default roles, see the NetBackup API documentation at http://sort.veritas.com/.