By default, anyone with a login can create a Package as the
public role has execute permissions on sp_add_dtspackage
stored procedure in msdb and the guest account is enabled in
msdb so it depends on whether you have changed this or not.
Other than that, the user would just need the appropriate
permissions for the objects they are accessing or actions
they are performing.
-Sue
On Mon, 19 Jul 2004 16:00:10 -0400, "john" <john@aic.com>
wrote:
Re: Does it require sa to create dts package? ... anyone with a login can create a Package as the ... stored procedure in msdb and the guest account is enabled in ...msdb by default so it depends on whether you have changed ... (microsoft.public.sqlserver.security)
Re: sql2k5 security ... you could give a user only Execute permissions on a ...stored procedure and the stored procedure could perform operations fine. ... Create a Schema named mySchema in the database.... (microsoft.public.sqlserver.security)
SQL Server Maintenance Routines/Procedures ... I recently learned that there is a stored procedure... sp_delete_backuphistory that cleans up the msdb for information related ... to backup jobs.... (comp.databases.ms-sqlserver)
Re: Unable to locate job scheduling stored procedures ... sp_add_job and all other SQL Server Agent stored procedure exist in the msdb...database,... You can fix this by either starting your script with "USE msdb", ... (microsoft.public.sqlserver.msde)
Re: Using xp_smtp_sendmail from a stored proc ... application that the user needs execute permissions on the extended stored ... > Grant EXECUTE permission on the stored procedure that you wrote ... >> grant users the execute right on the extended stored proc.... (microsoft.public.sqlserver.security)
