Error accessing CDR Tables

Version 1
    This document was generated from CDN thread

    Created by: Chandar vr on 16-09-2009 07:46:30 AM
    Hi all,
    I am getting error when i tried to  access the CDR table through executesqlquery soap api.
    2$querymyva=$client->executeSQLQuery(array('sql'=>"select * from car:tbl_billing_data where duration > 100"));

    I am getting the following error "No connect permission" and the error code is -387
    But when i execute the query from CLI i am getting the proper Data.
    Please help me on this.

    Subject: RE: Error accessing CDR Tables
    Replied by: David Staudt on 22-09-2009 02:49:53 PM
    Cross-posted from the SXML forums: