I appreciate your reply but I already supp;ied Grnt execute on those SPs which I am calling or application calls..

So looks like its something else

Thanks for the reply but yes the particular user belongs to that role

and I did run that script already and I can see some 10 SPs but

they are not really...

--I know it parses successfully but when I execute I am geting this rror

Msg 102, Level 15, State 1, Line 10

Incorrect syntax near 'APJPRD'.

I have 16 roles like this in...

Thanks for that but I already did that and I can see this error

Msg 156, Level 15, State 1, Line 16

Incorrect syntax near the keyword 'PRINT'