Cisco Cisco Workload Automation 6.3 Guida Utente

Introducing the Microsoft SQL Server Adapter

Prerequisites

If assigning the sysadmin role is not possible, then your user must be granted the permissions listed in the next steps.

Run the queries below to verify these have been granted: 

select has_perms_by_name('msdb..sysobjects', 'object', 'select')

select has_perms_by_name('msdb..sysproxies', 'object', 'select')

select has_perms_by_name('master..syslogins', 'object', 'select')

select has_perms_by_name('master..sysdatabases', 'object', 'select')

select has_perms_by_name('sys.objects', 'object', 'select')

select has_perms_by_name('sys.schemas', 'object', 'select')

select has_perms_by_name('sys.sysusers', 'object', 'select')

select has_perms_by_name('sys.syslogins', 'object', 'select') 

If one or more of the above permissions are missing, issue the following statements to grant them to your user. 
Assume your user is 

. 

grant select on object::msdb..sysobjects to [TIDALSOFT\myuser];

grant select on object::msdb..sysproxies to [TIDALSOFT\myuser];

grant select on object::master..syslogins to [TIDALSOFT\myuser];

grant select on object::master..sysdatabases to [TIDALSOFT\myuser];

grant select on object::sys.objects to [TIDALSOFT\myuser];

grant select on object::sys.schemas to [TIDALSOFT\myuser];

grant select on object::sys.sysusers to [TIDALSOFT\myuser];

grant select on object::sys.syslogins to [TIDALSOFT\myuser]; 

Ensure that your user has the following permissions for each database your SQL Adapter jobs reference. In the 
example below the database is called 

. 

select has_perms_by_name('[XYZ]..sysobjects', 'object', 'select')

select has_perms_by_name('[XYZ]..sysusers', 'object', 'select')

select has_perms_by_name('[XYZ]', 'database', 'showplan') 

If any of the above permissions are missing, issue the following statements:

grant select on object::[XYZ]..sysobjects to [TIDALSOFT\myuser];

grant select on object::[XYZ]..sysusers to [TIDALSOFT\myuser];

grant showplan on database::[XYZ] to [TIDALSOFT\myuser]; 

Ensure that your user can call these database functions. You do not need to assign any permissions by default. 

getDate()

getUtcDate()

getServerProperty()

suser_sname() 

Your user must be assigned the 

 role or one of the following SQL Server Agent roles: 

, 

 or 

. Only the 

 role can create, view and run all jobs in the 

database. Refer to SQL Server documentation about the restrictions placed on each of the SQL Server Agent roles with 
regard to jobs. Refer to the documentation about how to check which roles are assigned to your user and how to assign 
one of these roles to your user.

Database Events 

Monitoring database events requires your user be assigned to the 

 role and the 

role for each 

database being monitored.