Forum Replies Created

Viewing 5 posts - 1 through 6 (of 6 total)

  • RE: Using View to limit permissions in SQL Server 2005

    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...

  • RE: Using View to limit permissions in SQL Server 2005

    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...

  • RE: Using View to limit permissions in SQL Server 2005

    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?

  • RE: Using View to limit permissions in SQL Server 2005

    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...

  • RE: DB Mail problem

    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...

Viewing 5 posts - 1 through 6 (of 6 total)