Post reply

how can deny user who has full rights to prevent some tasks.

  • January 30, 2009 at 6:25 am

    #155202

    I want to create user so he has right all , but can not drop any database and any objects(sp, trigger, tables, FN)

    or how can deny user who has full rights to prevent above tasks.

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • January 30, 2009 at 6:49 am

    #935493

    Create a user and then carefully study what rights that user needs. Then Give the rights accordingly. If you want the user to have Select rights for one DB, Grant the User rights to that DB. (Add the user to the DB) and give db_Datareader. If the user needs right to insert or update or delete on the whole DB, give db_DataWriter rights.

    -Roy

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

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