January 15, 2010 at 2:12 pm
Hi Friends,
Iam having schema called "Reports" ,
This reports schema having tables and stored procs ,but
my question is
I need to give create permission in this schema to particular user?
for eg ;
Schema : Reports
User : Test
Stroed procedure to be created : Addition
How can i give create stored proc permission to user in this schema?
January 15, 2010 at 3:26 pm
January 18, 2010 at 2:14 pm
Grant CREATE PROC to a role. Add Users in that role.
Grant ALTER SCHEMA on the schema(s) that the Users need to modify stored procedures in to the role.
Grant VIEW DEFINITION on the schema(s) that the Users need to modify stored procedures in to the role.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply