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
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:
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?
Permission Problem
Forum Locked
Posted - 01/15/2003 : 23:58:33
