SAP Knowledge Base Article - Preview

2143485 - Error 10330 permission denied on object - SAP ASE

Symptom

  • Error 10330 is raised when performing a SELECT on a table that the user has permissions to allow:

Msg 10330, Level 14, State 1:
SELECT permission denied on object xxxxx_login_hist, database xxxx, owner dbo

  • Error 10331 is raised when performing a CREATE DATABASE user has permissions to allow:

Msg 10331, Level 14, State 3:
Permission denied, database master, owner dbo. You need the following
permission(s) to run this command: CREATE DATABASE.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.x
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

role, user-defined, activated, sp_modifylogin, "set role" Configured Authorization: , default off, default on, Msg 1809, Level 16, State 1: , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.