select id from cond with (nolock)

You probably just need to specify the schema. For example:

select id from ignite.cond with (nolock)

Or use the setuser command:

setuser 'ignite';

select id from cond with (nolock);

The above queries assume that "ignite" is the name of your DPA schema.

Hi roballen,

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

hello

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.

Here is a custom report for top SQL by user:  Custom Report - Top SQL for Database User

Feel free to modify as needed, but it shows the relationship between CONSW, CONST, and CONU (user).