Invalid defaulted table ?

General
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
Enthusiast

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

 

 eg.

              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 

 

Regards

Parthi