Viewing 5 posts - 1 through 6 (of 6 total)
Thanks everyone.....when we removed the user as owner of the schema...and ljust made sure this was his default schema and he had select permissions on the view...it worked as expected!!
Where...
March 4, 2008 at 1:35 pm
to continue...so the correct solution would be:
assuming dbo.tbl1 and dbo.tbl2 exist
otherschema.view that selects on dbo.tbl2, dbo.tbl2
usertst whose default schema is otherschema...but he no longer owns the schema would simply be...
March 4, 2008 at 12:30 pm
Okay...so all we need to do is not make this user the schema owner...but rather just give them select permissions to the view...regardless of schema?
March 4, 2008 at 12:28 pm
Thanks for the response...this is what we started with and it did not work as we expected. We granted select permissions to the view object...and when the user logs...
March 4, 2008 at 11:20 am
Hi...we had a similar problem ...look for hidden non-printable characters in the subject...like <carriage return>, <line feed>
Users had embedded a carriage return character in the subject..not visible when you are looking...
August 17, 2007 at 11:04 am
Viewing 5 posts - 1 through 6 (of 6 total)