MS SQL Server security - Permissions to public in the master database

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Permissions to public in the master database

Ian

2005-07-28, 11:26 am

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.

Sponsored Links