Sample Header Ad - 728x90

public role restrictions on a shared server prevent IntelliSense from working

0 votes
1 answer
182 views
I have an SQL Server 2016 database. This database is hosted on a **shared** server, and is managed by a central DBA team. In an effort to harden data security on the Production server, the DBA team has taken the approach to revoke/disable all public roles (i.e. DENY everything to the public role). I believe this was done to limit (meta)data access to *other* databases on the same server, presumably along these lines: https://dba.stackexchange.com/questions/220225/is-it-best-practice-to-revoke-server-permissions-to-the-server-public-role-on The problem is that this setup prevents IntelliSense from working on Microsoft SQL Server Management Studio. I think it's the situation Aaron Bertrand cautions on here: https://dba.stackexchange.com/a/116814/180921 I have elevated access rights (RWED) to my database, but am not a full admin (this role is restricted to members of the DBA Production team). **Is there a possible solution here? How can IntelliSense be made to work on my database, while respecting DBA desire to limit metadata view for *other* databases**
Asked by Roberto (119 rep)
Jul 18, 2022, 01:13 PM
Last activity: Jul 10, 2025, 06:03 AM