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

  • July 4, 2013 at 3:13 am

    #1629769

    how to give permission to create table and deny drop;

    DENY ALTER ON SCHEMA::DBO TO username -- if we aplly this then we cannot create table.

    i need to give permission to create table and deny drop