Post reply

How to grant access to 'sql_expression_dependencies' without granting dbo

  • March 27, 2018 at 2:23 pm

    #330067

    I have a group of support persons who need to be able to view the dependencies for whole Db or table. And they are being denied access 


    The SELECT permission was denied on the object'sql_expression_dependencies', database 'mssqlsystemresource', schema 'sys'.

    Any suggestions would be helpful. I have granted select on several but not the right object yet.  

  • March 27, 2018 at 3:06 pm

    #1984731

    https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-sql-expression-dependencies-transact-sql

    Permissions

    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.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 27, 2018 at 3:26 pm

    #1984734

    Thank you, will try to access the website from home. We are not allowed to access from work. 🙁

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply