Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
rahuldpawar
Starting Member
3 Posts |
Posted - 2003-01-15 : 23:58:33
|
recently we changed our database security policydue to which objects created in pervious user loginare 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
38200 Posts |
Posted - 2003-01-16 : 00:37:17
|
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 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-16 : 00:40:14
|
quote: recently we changed our database security policydue to which objects created in pervious user loginare 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.tablecould you elalorate more on whate do u mean change in database security policy?Expect the UnExpected |
|
|
|
|
|