Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    Unanswered: 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.
    Celia

  2. #2
    Join Date
    Apr 2004
    Location
    Melbourne
    Posts
    144
    can't u use the

    use databasename
    select * from table

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •