• I can issue "Grant Create Table to db_custom", no problem. but users only can create new table and no permission to alter tables.

    When I exec "Grant Alter Table to db_custom", got the error message,

    Msg 165, Level 16, State 2, Line 1

    Privilege ALTER TABLE may not be granted or revoked.

    By the way, the objects' owner is dbo.