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.You can run it with out the owner name, if you are logged in as the object owner. Otherwise, you have to specify it.|||...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
Thursday, February 16, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment