IBM Data & AI

Welcome to the idea forum for IBM Data & AI (Formerly Analytics) Clients! 


IBM Employees:

The correct URL for entering your ideas is



Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.


If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.


Create a separate role for federation.

I tried the suggestions made by John yesterday and it seems to be working so here are two ways to enable user to use federation in self-service mode.   1.      Grant user a sysadmin privileges which comes with elevated privileges. User can even make changes to db2 configs. 2.      Another option is to create the server definition in data server manager as sys admin user such as bigsql and create user mapping for each and every user, and then let user create the nicknames of tables they like.   I was discussed with my boss and he doesn’t like either suggestion. First solution exposes a larger set of privileges than required, and another option increases the security risk and add additional overhead. May we request for an enhancement to create a low privileged role just for federation?

  • Guest
  • Dec 14 2018
  • Needs review
Customer Name
Role Summary Hadoop Administrator
  • Attach files

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions