Home Forums SQL Server 2005 SQL Server 2005 Security Deny delete and drop permission to the sql user RE: Deny delete and drop permission to the sql user

  • October 8, 2008 at 12:50 am

    #882114

    anjan.ashok (10/7/2008)

    hi dugi

    one problem delete permission is restricted but the testuser can drop the table

    any idea how to fix this issue?

    Maybe you didn't run the script in correct and can you tell me you user, member of what role is!?

    Try that your user to be the member of "db_datawriter" role!

    Here is the commands:

    DELETE PAYROLL

    WHERE No = 2;

    MSG:

    Msg 229, Level 14, State 5, Line 1

    The DELETE permission was denied on the object 'Payroll', database 'TEST', schema 'dbo'.

    And

    DROP TABLE PAYROLL;

    GO

    MSG:

    Msg 3701, Level 14, State 20, Line 4

    Cannot drop the table 'Payroll', because it does not exist or you do not have permission.

    For me works fine and everything is correct!

    :w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]