Skip to Content
Former Member
Aug 03, 2005 at 10:17 AM

DB Connect to MSQL database - authorisation ?



I like to extract data from MSS system (our BW is 3.1). Thus I followed all advices (OSS, SDN network) like upper case, user-own table ect. However I am not able to get a proper connection. Thus I am wondering if someone has an idea for the following:

In the 'DB connect: Table and view overview', I can only see the table of the MSS database owner. Unfortunately the view built specifically by the extraction-user doesnÂ’t appear in the 'DB connect Table and view overview'.

Thus has someone an idea, which authorisation is required for the extraction user in MSS at least to get this view in 'DB connect Table and view overview'.

Anyhow it would be excellent if someone could provide an extract of the given authorisation to his user, which is able to extract successfully data.

Best regards


PS: Through EXCEL /ODBC using same user and view the data extraction is successful.