| JayRav 2005-10-28, 5:03 pm |
| Hi,
I was trying to add a database fact for a column in my database. But, all
tables in my dB are by standard , created and referred to as dd.<TableName>
where dd is the user or group name. Here, the database is mostly accessed
using another user name "DBUser".
So, when I tried to create a table column fact and access the fact using
"DBUser" name and password, all the tables appear with only <TableName> and
not "dd.<TableName>" in the database explorer. On attempting to access the
table an error is thrown saying "Invalid object'. I suppose because the name
appears as only <TableName> without the prefix "dd" this causes access
problems here.
Any ideas on how this problem might be solved. Any help is greatly valued.
Regards,
JayRav
|