GRANT ALTER PROCEDURE | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


I am trying to grant permissions on individual objects in SQL 2K and wanted to know the syntax of the statement or if there would be configuration necessary to allow this in SQL Server. If anyone who has run into this could give me a push on a simple GRANT command it would be greatly appreciated. I am thinking of something simular to GRANT ALTER PROCEDURE ON xxxx(object) TO yyyy(User account). I have granted simular permissions in Oracle but don’t know if this is allowed in SQL. Any ideas?
Read about GRANT in BOL under granting permissions…
its like this…. GRANT {all/select/create/other priviledges/permissions} on {object name}
TO {account/group}