Setting up Job Scheduler users

Set up users so they can create, manage, or execute jobs and schedules in the sybmgmtdb database.

Setting up users for Job Scheduler

1. Add users to the sybmgmtdb� database:

   use sybmgmtdb�
   go�
   sp_adduser local_login_name�
   go
   

   where local_login_name is the user's login name on the Job Scheduler server.

2. Grant the appropriate roles to users:

   For Job Scheduler administrators:

   sp_role 'grant', js_admin_role, local_login_name�
   go 
   sp_modifylogin local_login_name, 'add default role', js_admin_role�
   go
   
   

   For Job Scheduler users:

   sp_role 'grant', js_user_role, local_login_name�
   go
   sp_modifylogin local_login_name, 'add default role', js_user_role�
   go 
   
   

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF