the sap-users are stored in table usr02. this belongs to the sap-database-user SAP<SID>, so you can access it with sqlcli -d <SID> -u sap<SID>,<password> "select * from usr02"
search for all the user-names in client 100: select bname from usr02 where mandt='100' alex -----Ursprüngliche Nachricht----- Von: Lorainne [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 3. November 2006 08:54 An: maxdb@lists.mysql.com Betreff: How to filter all SAP users from maxdb? 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. -- 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]
