Symptom
- ASE 15.7 GA (base release).
- 'Create Function' and 'Set Tracing' do not exist in spt_values.
- The following two queries return 0 row:
select * from master.dbo.spt_values where name='Create Function'
go
select * from master.dbo.spt_values where name='Set Tracing'
go - The column 'number' in spt_values is associated with the column 'action' in sysprotects. It indicates what permissions are granted to users. Missing ‘Create Function’ and ‘Set Tracing’ entries in spt_values cause integrity issues on spt_values and sysprotects.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 GA Only
Product
SAP Adaptive Server Enterprise 15.7
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.