Grant privileges to the gateway database user

Products

• CA API Gateway

Issue/Introduction

What is the justification and need for the '<ADU>' user to have access to the database's mysql schema and not just the ssg schema. Without this permission, will the gateway API not work correctly?

Environment

API Gateway: 10.X

Resolution

The gateway database user needs all privileges on the ssg.* with grant option database. It does not need permissions on the mysql.* database.