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
Last activity: Jul 10, 2025, 06:03 AM