Symptom
- Upgrading NetWeaver version fails in Phase: PREP_INIT/SYB_CHK_PRIVILEGES
- With database error 4630:
"You must be in the the default database for the user 'SAPSR3' (the 'master' database) in order to GRANT or REVOKE builtin"
- Entries in SYB_PRP_SESSVAR.LOG show:
1 ETQ399 Executing SQL script '../var/SYB_PRP_SESSVAR.TSQL'.
....
4 ETQ394 "Changed database context to 'SID'."
...
3 ETQ398XSQL: 'grant select on builtin set_appcontext to SAPSR3 grant select on builtin get_appcontext to SAPSR3 grant select on builtin rm_appcontext to
3 ETQ398XSQL: SAPSR3 ')
1EETQ008 Error message: DBSL error 99 (db code 4630):
1EETQ009X[ASE Error SQL4630][SAP][ASE ODBC Driver][Adaptive Server
1EETQ009XEnterprise]You must be in the the default database for the user
1EETQ009X'SAPSR3' (the 'master' database) in order to GRANT or REVOKE builtin
1EETQ009Xaccess.
1EETQ003 exit code: "20"
4 ETQ399 Rollback.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
error 4630 , SQL4630 , permission , default database , SAPSR3 , SYB_CHK_PRIVILEGES , SYB_PRP_SESSVAR.TSQL , SYB_PRP_SESSVAR.LOG , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.