Popular Posts

Tuesday, July 26, 2011

Permission to User

Give permission to user for execute object in SQL server.

grant execute on OBJECT_NAME to USERNAME

Example:-
grant execute on usp_store to user_jasraj

Permission on Table
grant insert on tblName to user_JasRaj