Grant SELECT permission on a view, but not on underlying objects

by

Does the same user who owns the view also own the underlying tables? If not, the owner of the tables needs to grant the view owner permission WITH GRANT OPTION. If the same user owns both the tables and the view, then granting permission on the view should be sufficient.

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. CROSS JOIN vs INNER JOIN in SQL
  3. Unpivot with column name
  4. How to generate a range of numbers between two numbers?
  5. SET versus SELECT when assigning variables?
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Generate Dates between date ranges
  8. How to print VARCHAR(MAX) using Print Statement?
  9. Check if a row exists, otherwise insert
  10. How to update Identity Column in SQL Server?
  11. Common Table Expression, why semicolon?
  12. T-SQL split string based on delimiter
  13. Concatenate values based on ID
  14. Splitting delimited values in a SQL column into multiple rows
  15. Select a Column in SQL not in Group By
  16. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  17. Restrict an SQL Server connection to a specific IP address
  18. How does this CASE expression reach the ELSE clause?
  19. TransactSQL to run another TransactSQL script
  20. Stored procedure that exports data into csv files only exports to one file
  21. How can I group time by hour or by 10 minutes?
  22. Do clustered indexes have to be unique?
  23. How do I prevent a database trigger from recursing?
  24. TSQL – How to use GO inside of a BEGIN .. END block?
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. Repeat Rows N Times According to Column Value
  27. SQL take just the numeric values from a varchar
  28. COALESCE Function in TSQL
  29. Execute sp_executeSql for select…into #table but Can’t Select out Temp Table Data
  30. Select rows where column value has changed

Leave a Comment