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.
SAP Knowledge Base Article - Preview