user defined database roles permissions

  • If I wanna give some users alter permission to certain stored procedure then I create a user defined database role and then give permissions to alter and then add the member. Where is this information stored in the system database? or I will appreciate if somebody can help me script out this whole thing like creating the user defined database roles and then assigning securables ..

  • For creating a new role check sp_addrole in BOL.

    About handing out permissions to a role or user search for GRANT

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply