Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

Permission denied for table when querying in WebApp

vendimb15716755
Level 4
Level 4

Hi

in the Adobe campaign Classic v7. I am executing a query from the webapp when the user subscribe to get some reward code and inject into email . I am having permission issues when webapp trying to execute the query even though the webapp user have Administration rights( some time it works though) .. The webapp access control is set up as Anonymous access. The funny thing is that there is another query that gets execute fine. The table that is getting queried is under a custom schema .

below is the query that get executed

 

var query = xtk.queryDef.create( <queryDef schema="vb:promoCodes" operation="select" lineCount="1">
<select>
<node expr="@promoCode"/>
<node expr="@codeStartDate"/>
<node expr="@codeEndDate"/>
<node expr="@id"/>
</select>
<where>
<condition expr="@codeStartDate <= GetDate()"/>
<condition expr="@codeEndDate >= GetDate()"/>
</where>
</queryDef>)

var promoCodes = query.ExecuteQuery();

 

error below

Error | Function getpromoCode() failed | PGS-220000 PostgreSQL error: ERROR: permission denied for table vbpromocodes .

SOP-330011 Error while executing the method 'ExecuteQuery' of service 'xtk:queryDef'

6 Replies
wodnicki
Community Advisor
Community Advisor

Hi,

 

The error is coming from postgres there.

Check that Campaign's db user has read access to the vbpromocodes table.

 

Thanks,

-Jon

vendimb15716755
Level 4
Level 4
Thanks Jon, The Schema was created from the AC UI as I dont have acess to the PostgreSQL. can the permissions assigned from the Campaign itself when the schema gets created?
vendimb15716755
Level 4
Level 4
hi @wodnicki , any thoughts on my question? the webapp is able to query all the other object beside this and the schema was created from the AC via UI.
saikatk2447661
Level 4
Level 4

Hi @vendimb15716755 ,

 

Could you please explain the reason behind "Function getpromoCode()". Is @promoCode coming from a calculated field?

 

Thanks,

Saikat

vendimb15716755
Level 4
Level 4
The Function getpromocode is coming from Javascript code. withing the webapp I am including reference to the javascript code that does all the logic. @promocode is not a calculated field. its just a column on a schema that holgs promo codes