You probably just need to specify the schema. For example:
select id from ignite.cond with (nolock)
Or use the setuser command:
select id from cond with (nolock);
The above queries assume that "ignite" is the name of your DPA schema.
I just figured that out myself but now I understand why.
Thanks for the reply!
Just add the full name of the database schema and you should be good
i'm trying to generate custom reports based on usernames and the SQL they are executing. do you have table details of how i can get this on ignite? i know the CONST_2 table stores the query details but i dont know which table to link it with in order to get the user exectuing the SQL.