Lorainne wrote: > > Hello list, > > Let me start by mentioning that I am not a very expierenced > maxdb user. > We are using SAP (ERP and CRM) running on RedHat Linux, using Maxdb as > database system. > I have been searching half the internet how to retrieve a list of SAP > users directly from maxdb by using a query from the commandline. > > > /sapdb/programs/bin/sqlcli -u <USER>,<PASSWD> -d EDV "select > * from users" > is not what I need. I am really looking for the application users. > > Could you perhaps point out which table or column I need to look into? > > Cheers, Lorainne.
As I understood you are NOT looking for the users known in the database, but the users allowed to use the application, are you? USERS is the list of database users. There is no MAXDB-specific table where these application users are stored. This may (or may not) handled by the application, perhaps stored in the database somewhere. And therefore it is much better to ask SAP support where to find this info. The database people will not be able to help. Elke SAP Labs Berlin > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]