In SSMS if I have given permission to a Table than its permission should also be applied to its dependencies indirectly

Shabnam A. Shaikh 0 Reputation points
2024-04-18T04:52:15.0533333+00:00

In SSMS if I have given permission to a Table than its permission should also be applied to its dependencies indirectly 

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,738 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,896 Reputation points
    2024-04-18T05:38:28.68+00:00

    should also be applied to its dependencies indirectly 

    That's not how permissions work in SQL Server, exactly it's the other way round. If you grant permissions on a view or procedure, then the user don't need permissions on the base table; called ownership chaining.

    See Tutorial: Ownership Chains and Context Switching

    0 comments
  2. ZoeHui-MSFT 33,126 Reputation points
    2024-04-18T06:49:55.2466667+00:00

    Hi @Shabnam A. Shaikh,

    If you want to view the dependencies of the table, it requires VIEW DEFINITION permission on the database and SELECT permission on sys.sql_expression_dependencies for the database.

    By default, SELECT permission is granted only to members of the db_owner fixed database role. When SELECT and VIEW DEFINITION permissions are granted to another user, the grantee can view all dependencies in the database.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments