November 9, 2005 at 10:54 am
I've got a Database, with an owner other than dbo. The db_owner (stuser) also has ownership of all the user tables and stored procedures that were created. When I log into Query Analyzer as 'stuser', and try to select from one of the tables I own, I get:
Invalid Object 'tablename'.
If I own the table, i shouldn't have to specify owner.tablename in the query. What could i have set wrong or what do I need to do to correct this?
Any guidance is appreciated greatly.
Thanks
November 9, 2005 at 12:14 pm
Give stuser system administrator privilege from server roles.
That will help query run without specifying owner name
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
November 9, 2005 at 12:38 pm
It is considered a best pratice to ALWAYS specify the owner of the object (any object). This is one of the many reasons. Also I think you can alias the login to dbo but I don't know if it's the same as giving the user system privileges (which could be considered to be bad in this case).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply