Wednesday, March 21, 2012

Permissions Problem

I have got a peculiar problem. I am not able to query my tables without db username prefix like username.tablename. Worse, I have logged in as username.

Any ideas on what could be the problem?

Now I have to give queries like select * from celia.orders instead of just select * from orders.

Thank you.
Celiacan't u use the

use databasename
select * from table

if it was permission, you probably won't be able to see the tables.

No comments:

Post a Comment