Hello,
In our enterprise infrastructure, our SQL Server is hosted by an internal hosting service, which will not grant us DBO access on the SQL Server. At install, the SQL Server Administrators will have DBO access, so we don't have any concerns there, but at runtime we do have concerns regarding what rights / credentials are needed? I noticed that there are quite a few stored procedures - do we need DBO access for any of these stored procedures? I noticed that the owner of all these stored procedures is dbo, but is it necessary to have dbo credentials?
Thanks,
Shawn
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.