I want to create a policy which enables xp_cmdshell for a specific database. When I choose Database or DatabaseSecurity as my facet I don't get a choice for xp_cmdshell. When I choose ServerSecurity I do.
I've also tried setting it up as a ServiceAreaConfiguration facet but then I don't see anything to select in "targets".
Bottom line, can I enable this for a specific DB or can I only enable it server wide?
As you suspect, the xp_cmdshell option (http://technet.microsoft.com/en-us/library/ms190693.aspx) is a server-wide configuration option, and isn't configurable at the database level. If enabled, xp_cmdshell
We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.