Results 1 to 2 of 2

Thread: Object permissions might be a heache

  1. #1
    Viv Guest

    Object permissions might be a heache


    Hello!

    I created two differnt objects in a database. Let say user1 is the database object owner.

    Now the probelm starts when I use the query analyzer for just selecting the data using sa account(sa is the admin to all db) and when happens is that I cant't read the data using SQL QUERY ANALYZER but if I go to the TBALES through explorer then I can open the table using the same sa account.

    Is there anybody explain me why its happening?

    Thnaks

  2. #2
    Ray Miao Guest

    Object permissions might be a heache (reply)

    Try this

    select * from db_name.owner.table_name


    ------------
    Viv at 5/8/2002 10:53:19 AM


    Hello!

    I created two differnt objects in a database. Let say user1 is the database object owner.

    Now the probelm starts when I use the query analyzer for just selecting the data using sa account(sa is the admin to all db) and when happens is that I cant't read the data using SQL QUERY ANALYZER but if I go to the TBALES through explorer then I can open the table using the same sa account.

    Is there anybody explain me why its happening?

    Thnaks

Posting Permissions

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