Grant Select on a view not base table when base table is in a different database

by

As you state in one of your comments that the table in question is in a different database, then ownership chaining applies. I suspect there is a break in the chain somewhere – check that link for full details.

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. SQL server query to output the data shown below
  3. hide/remove header and footer
  4. What is the difference between Integrated Security = True and Integrated Security = SSPI?
  5. How to use a variable for the database name in T-SQL?
  6. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  7. Create a view with ORDER BY clause
  8. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  9. INSERT INTO vs SELECT INTO
  10. Possible to store value of one select column and use it for the next one?
  11. How to view transaction logs in SQL Server 2008 [closed]
  12. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  13. How can I Insert data into SQL Server using VBNet
  14. Using NOLOCK Hint in EF4?
  15. Will GETUTCDATE() return the same value if used twice in the same statement?
  16. Convert decimal time to hours and minutes
  17. Remove all spaces from a string in SQL Server
  18. Create table (structure) from existing table
  19. Milliseconds wrong when converting from XML to SQL Server datetime
  20. Using GROUP BY with FIRST_VALUE and LAST_VALUE
  21. “Prevent saving changes that require the table to be re-created” negative effects
  22. What are the differences between Merge Join and Lookup transformations in SSIS?
  23. Convert UTC Milliseconds to DATETIME in SQL server
  24. Table Valued Function Killing My Query Performance
  25. freeTDS not using its config
  26. @@ERROR and/or TRY – CATCH
  27. replace NULL values with latest non-NULL value in resultset series (SQL Server 2008 R2)
  28. How to make a passthrough / passthru query editable?
  29. How to do Sql Server CE table update from another table
  30. Tool for Scripting Table Data

Leave a Comment