---
title: "Discussion on \"Microsoft SQL Server permission chaining\" | Hashnode"
description: "Discussion on \"Microsoft SQL Server permission chaining\". Many times, views are used as a security object; Granting select on a given view instead of the underlying table(s). Now if this view happens to cross schemas you might get an error saying the user does not have select permission on the underlying ta..."
url: "https://hashnode.com/posts/microsoft-sql-server-permission-chaining/683d3acfd427aab4346e0d6c"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Microsoft SQL Server permission chaining](https://josefrichberg.com/microsoft-sql-server-permission-chaining?utm_source=hashnode&utm_medium=feed)

Many times, views are used as a security object; Granting select on a given view instead of the underlying table(s). Now if this view happens to cross schemas you might get an error saying the user does not have select permission on the underlying ta...

Jun 2, 2025 · 1 min read · josefrichberg.com  
Read the article

-   [#microsoft-sql-server](https://hashnode.com/tag/microsoft-sql-server)
-   [#permissions](https://hashnode.com/tag/permissions)

## Written by

[Josef Richberg](https://hashnode.com/@josefrichberg)

@josefrichberg · Pennsylvania, US

  
[View profile](https://hashnode.com/@josefrichberg)

Principal Data Architect, Azure @ Penguin Random House

I've been working in and around SQL for over 3 decades. I am currently working on making our business intelligence systems self-driven by using an event-based architecture. This involves providing curated data in some of the largest SQL Azure Analysis Services cubes ever built (over 6 billion records in 1 table alone). I've developed several APIs leveraging a serverless Azure architecture to provide real-time data to various internal processes and projects. Currently working on Project Dormouse; Durable select messaging queue that enables polling processes to extract specific messages.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
