DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Revoke Select on permissions from all tables and Views

Hybrid View

  1. #1
    Join Date
    Jan 2022
    Posts
    1

    Revoke Select on permissions from all tables and Views

    Hello all,
    Three things: 1 I need to display all tables/views with select permissions 2 I need to revoke select for these tables/views except for DBO 3 I need to verify they are removed. This requirement is from a Appdetective scan i have been tasked to remediate. FINDING is Permission to select from system table. Suggested remediation is:No permissions should be granted on these tables (System views in SQL Server 2005 and later). Only database administrators should have access to select from these tables or views, which they have automatically since they are mapped to the dbo user and are the system table or views owners. To revoke permissions from the system tables or system views, execute the following command for each permissions found: REVOKE SELECT ON [table/view] FROM [user or group] CASCADE . I am using SQL 2016 Please help a Novice DBA

  2. #2
    Join Date
    Aug 2023
    Posts
    3
    Quote Originally Posted by Wade View Post
    Hello all,
    Three things: 1 I need to display all tables/views with select permissions 2 I need to revoke select for these tables/views except for DBO 3 I need to verify they are removed. This requirement is from a Appdetective scan i have been tasked to remediate. FINDING is Permission to select from system table. Suggested remediation is:No permissions should be granted on these tables (System views in SQL Server 2005 and later). Only database administrators should have access to select from these tables or views, which they have automatically since they are mapped to the dbo user and are the system table or views owners. To revoke permissions from the system tables or system views, execute the following command for each permissions found: REVOKE SELECT ON [table/view] FROM [user or group] CASCADE . I am using SQL 2016 Please help a Novice DBA
    I hope your question was answered here.
    So that will be helpful for me as well.

  3. #3
    Join Date
    May 2024
    Posts
    1
    Sounds like a DBA puzzle! Have you tried scripting it out? Might save you some time. Good luck with the remediation!


    **Links removed by Site Administrator so it doesn't look like you're spamming us. Please don't post them again.**

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width