You should really read the documentation for the SQL Server permissions system and specifically the parts about permissions in the ALTER PROCEDURE and the discussion of stored procedures in GRANT. This has no specific relevance to accessing the database using the DBI. I would suggest you take your SQL Server questions to somewhere interested in SQL Server after, of course, you have read the documentation.

/J\