locked
hi how to give accesing permission to a particular database RRS feed

  • Question

  • Hi all,

    I am working as dba how i can give the accesing permission to single data base to a particular user how i can give the permission

    please help & provide Some use full links for administration

    Thanks & regards

    Sunil Yoganna

    Wednesday, January 12, 2011 5:15 AM

Answers

  • Sunil Yoganna

    It is pretty easy to use SSMS

    1) Expand desired database (click on plus)

    2) Expand security foder under desired database (click plus)

    3) Right click on the Users foder and then new user

    4) Provide a name for user amd mapped him to the login

    Loking down  you will database fixed roles  you can add that user


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by WeiLin Qiao Friday, January 14, 2011 11:24 AM
    • Marked as answer by WeiLin Qiao Monday, January 24, 2011 10:53 AM
    Wednesday, January 12, 2011 8:31 AM

All replies

  • Sunil Yoganna

    It is pretty easy to use SSMS

    1) Expand desired database (click on plus)

    2) Expand security foder under desired database (click plus)

    3) Right click on the Users foder and then new user

    4) Provide a name for user amd mapped him to the login

    Loking down  you will database fixed roles  you can add that user


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by WeiLin Qiao Friday, January 14, 2011 11:24 AM
    • Marked as answer by WeiLin Qiao Monday, January 24, 2011 10:53 AM
    Wednesday, January 12, 2011 8:31 AM
  • Sunil Yoganna

    It is pretty easy to use SSMS

    1) Expand desired database (click on plus)

    2) Expand security foder under desired database (click plus)

    3) Right click on the Users foder and then new user

    4) Provide a name for user amd mapped him to the login

    Loking down  you will database fixed roles  you can add that user


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Wednesday, January 12, 2011 8:32 AM
  • Hoa can i do this from a sql script?
    Monday, August 8, 2011 12:36 PM