Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Posts
    9

    Unanswered: Can I run a select statement w/o specifing the owners table name?

    Can I run a select statement w/o specifing the owners table name?

    How is it possible to run a select query without specifing the owners table name?
    For example:

    To use:

    Query1: Select * from customers;

    instead of

    Query 2: Select * from user1.customers;

    Now, when user1 or even user2 tries to open the Query1 I get the error that object 'customers' does not exist.
    Last edited by AJV; 07-09-03 at 08:55.

  2. #2
    Join Date
    Dec 2002
    Posts
    63
    You can run it with out the owner name, if you are logged in as the object owner. Otherwise, you have to specify it.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    ...unless the owner is dbo. If all your tables are dbo owned you don't need to specify the owner as dbo is assumed as default.

    blindman

Posting Permissions

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