Thank you for sharing, I am getting an error when I setup/install: replace macro tdbench7.qlr(MinutesBack integer default 30, username varcha r(30) default user) as ( select * from tdbench7.ql where starttime > current_timestamp - cast(:MinutesBack as interval minute ) and ( (position('%' in :Username) > 0 and username like :username) or username = :Username ) order by starttime; ); *** Failure 5315 An owner referenced by user does not have SELECT WITH GRAN T OPTION access to DBC.DBQLogTbl.QueryID. Statement# 1, Info =0 *** Exiting BTEQ... *** RC (return code) = 8 can you share some light? thanks
Thanks a lot for the video and it's really good explanation .
Glad you liked it!
Thank you for sharing, I am getting an error when I setup/install:
replace macro tdbench7.qlr(MinutesBack integer default 30, username varcha
r(30) default user) as (
select * from tdbench7.ql
where starttime > current_timestamp - cast(:MinutesBack as interval minute
)
and (
(position('%' in :Username) > 0 and username like :username)
or username = :Username
) order by starttime;
);
*** Failure 5315 An owner referenced by user does not have SELECT WITH GRAN
T OPTION access to DBC.DBQLogTbl.QueryID.
Statement# 1, Info =0
*** Exiting BTEQ...
*** RC (return code) = 8
can you share some light? thanks