Invalid defaulted table ?

General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything

Invalid defaulted table ?

Hi Team,


  I am aware that we can declare a default database name infront of any sqls in BTEQ and that database will be applicable withing BT ET



              Database db1;

              select * from employee;

 The above query is same as

             select * from db1.employee;

For some reason this is not working in my new work environment, does it need any access privilages assigned by DBA