November 13, 2013 at 11:53 am
I am attempting to upload a file to a table using BCP on a secure (STIG) SQL Server. User have almost no permissions on master. It seems that the admins on the server have managed to remove the public role, or at least rovoked most of the permissions granted to public.
So far we have identified, by reading error logs as we cannot run profiler on the remote server, some of the master database objects that are required by BCP, such as sp_tablecollations100. Does anyone know the complete list of database objects requirted by BCP?
November 13, 2013 at 4:22 pm
No, but I do know that you're never supposed to remove the Guest account from master. Basically SQL requires it. Put it back and try again before making any other changes.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply