Installation of SAP IQ users mandatory requirement
When I was going through the installation guide I had seen that we need to have a user name called Sybase in order to install SAP IQ.
My question is that we don't have a concept of local users and we wanted to have a different username for each NLS system rather than using the user Sybase across the landscape.
Can we have users created as syb<sid> as we have in Sybase ASE?
Is this approach supported or else Sybase user is a mandatory requirement.
Mark Mumy replied
I know that in our internal systems we use something other than 'sybase' for these instances and our testing. The user name really is immaterial for IQ. I would recommend that you use a login that is related to your BW instance, as you mentioned a SID could work.
There is no reliance in BW on the OS level user/login for IQ. All connectivity and dependencies are at the database level and the database users and logins.