Monthly Archives: September 2005

Grant permissions on xp_cmdshell and sp_OACreate family SPs

The defualt permissions to run xp_cmdshell and sp_OACreate family system stored procedures are members of sysadmin server role. However, use a login with sysadmin privilge to run an application is risky, thus not a good practice.   If an application … Continue reading

Posted in SQL server | 1 Comment