Post reply

database roles and permissions

  • June 29, 2006 at 7:49 am

    #97189

    Hi,

    I want to create database role , add users, givie permissions as

    SELECT,UPDATE,INSERT,DELETE,and EXECUTE to database role.

     

    Ans also how can role back rollback that (which means how can I drop role)?

    Please please help me.

    Thanks in advance.

     

     

  • July 3, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 5, 2006 at 11:47 am

    #647583

    Hello there!

    here is the solution. follow the step by step procedure given below

    1.Open the Enterprise Manager

    2.Expand ther server group and exapnd your server

    3.Expand the database folder

    4.Expand the database which you want to create the role

    5.right click the role ----->new database role --- >type the role name in popup window

    6. click add button to add the users under the role

    7. click the permission button where you can see the objects(tables,view,Stored procedure) belongs to corresponding DB and their permission SELECT,UPDATE,INSERET,DELETE, EXECUTE ON THE FIRST ROW.

    8.Set the grand permission(right mark) by clicking the checkbox as well as deny the permision by setting the 'X' by clicking second click

    9.log into sql server and try to access the tables and verify the permission on the table,stroed procedure and view.

    note : you must be have admin permission to create role permission

    Thanks

    Seenivasan.R

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

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