Symptom
A login with js_admin_role can't disable a job from another login using 'all_users' option.
sp_displaylogin
suid: 17
Loginame: prjaman
Login Profile: DBA_login_profile
sp_securityprofile 'attributes','login profile', DBA_login_profile
Name Value
-------------------- -----------------
login profile DBA_login_profile
auto activated roles js_admin_role
auto activated roles mon_role
auto activated roles oper_role
auto activated roles sa_role
auto activated roles sso_role
sp_sjobcontrol @name='updtInxStats', @option='disable,all_users'
Msg 19083, Level 16, State 1:
Server 'myserver', Procedure 'sp_sjobcontrol', Line 465:
Procedure sp_sjobcontrol, you do not have permission to access the specified scheduledjob, job, schedule or running job - @name.
(return status = -19083)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.
- Job scheduler
Product
Keywords
19083,all_users,sp_sjobcontrol,disable,job scheduler , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.