A community member has associated this post with a similar question:
How can you enforce restrictions on user access to a database table, preventing indirect access through views, procedures, or GUI operations, without relying on SQL scripts?

Only moderators can edit this content.

How can I use the SQL Server GUI to deny access to a specific table and ensure that access is automatically denied wherever this table is used throughout the database?

Shabnam A. Shaikh 0 Reputation points
2024-04-16T07:20:24.9966667+00:00

How can I use the SQL Server GUI to deny access to a specific table and ensure that access is automatically denied wherever this table is used throughout the database?

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. LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
    2024-04-17T07:03:41.2666667+00:00

    Hi @Shabnam A. Shaikh,

    Thanks for your information.

    Coincidentally, I just finished a study in the similar issue a few days ago. You can follow this article step by step; it provides information in detail.

    Please feel free to share your issue with us here.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications

  2. LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
    2024-04-18T06:07:58.58+00:00

    Hi @Shabnam A. Shaikh,

    Thanks for your information.

    If you want to enforce restrictions on user access to a database table, I followed the steps in this article, and I change the permission of the table:

    User's image Then you can now view-only permissions on the tables you have specified. You cannot access any data.

    User's image

    User's image Please feel free to share your issue here.

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications