Permissions to public in the master database

From: Ian (Ian_at_discussions.microsoft.com)
Date: 07/28/05


Date: Thu, 28 Jul 2005 09:37:02 -0700

The company I work for provides an application that runs on SQL Server 2000.
One of our customers is requiring that we revoke all access granted to the
public role in master and create a user-role with the appropriate
permissions. I am reluctant to do this since I don't believe we should be
messing with the master database at all. I also found the following in a
post on one of the communities, "Should you alter permissions in master, your
SQL Server becomes an unsupported configuration so far as Microsoft is
concerned. If you have to call in support and they determine you've changed
permissions, they'll force you to roll back your changes before proceeding
any further." which supports my position. Is this indeed a true statement
and if so will Microsoft tell me this "officially" in order to present this
position to the customer.



Relevant Pages

  • Re: Detailed User Access Rights
    ... Sysadmin role members have full SQL Server permissions and OS permissions ... > 2) Now that my customers can create their own views etc, ... GRANT SELECT ON MyTableFunction TO CustomerUser ...
    (microsoft.public.sqlserver.security)
  • Re: Block User Viewing Vies & Procedures
    ... sp_helptext in master has public execute permissions by default and master ... that didn't work by defining the roles and permissions in the previous post ... Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)
  • ADP, Application Role, and objects
    ... The above link is to an atricle on how to implement SQL Server Application ... After you connect with your ADP, fire a bit of code to set the ... third party tools to view the data on the same database. ... Scenario 1 - If I explicitly grant permissions on that object to the user ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Please answer my queries for fresh Installation
    ... You can restore MSDB as well as master. ... > SQL Server, It will create Master, MSDB databases. ...
    (microsoft.public.sqlserver.server)
  • Re: field level security question
    ... Vyas, MVP ... listBox control that gets data from a query of the sql server table. ... > recent change in requirement) I see the option to limit permissions right ... > utility opens except their is just no data. ...
    (microsoft.public.sqlserver.security)