SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Permission Problem
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

rahuldpawar
Starting Member

3 Posts

Posted - 01/15/2003 :  23:58:33  Show Profile
recently we changed our database security policy
due to which objects created in pervious user login
are not executable in the new user login although we have given all permission to new user on all objects but it still gives following error "Invalid object name 'xyz' " though 'xyz' is there in root.
please help us

tkizer
Almighty SQL Goddess

USA
37134 Posts

Posted - 01/16/2003 :  00:37:17  Show Profile  Visit tkizer's Homepage
You will need to refer to the object with the object owner. So for example if your table is called Table1 and the owner is called user1, then you would do a select like this:

SELECT TOP 1 *
FROM user1.Table1


Go to Top of Page

harshal_in
Aged Yak Warrior

India
633 Posts

Posted - 01/16/2003 :  00:40:14  Show Profile  Visit harshal_in's Homepage  Send harshal_in a Yahoo! Message
quote:

recently we changed our database security policy
due to which objects created in pervious user login
are not executable in the new user login although we have given all permission to new user on all objects but it still gives following error "Invalid object name 'xyz' " though 'xyz' is there in root.
please help us




yes this is what I had just typed ;)
select * from dbo.table


could you elalorate more on whate do u mean change in database security policy?



Expect the UnExpected
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000