Hi,

Can anyone assist me on this below:

I have a database called appdb. I need to grant access to this db to different users say: api_user, app_user, portal_user. 

So I created a ROLE as APP_ROLE and GRANT as below:

GRANT SELECT, INSERT, UPDATE, DELETE ON APPDB.* TO APP_ROLE;

Later I assign the Role to user:

GRANT APP_ROLE TO API_USER@'%' IDENTIFIED BY 'YOU';

SET DEFAULT ROLE APP_ROLE TO API_USER@'%';

But the problem now is:

Application team want to choose the database when they establish connection. But they couldn't use APPDB. 

So they couldn't see  any db objects listed in APPDB. Is there a way we can assign a default database also for user.