Date parsed: 18/10/2007 17:15:24
Date: Thu, 18 Oct 2007 15:15:24 +0200

db
If you make him to be owner of the table. Such as CREATE TABLE user.T(c
INT...)"db" <db@discussions.microsoft.com> wrote in message
news:0C3AA563-11A3-42FA-989D-6330159005A3@microsoft.com...
> Product: Microsoft SQL server Enterprise Edition (2000)
> O/S: MS Windoes NT (5.2)
> Version: 8.00.760
> =====================================================
> Can we grant (Alter table) permission on a single table on a database?
> ( I need to create a new user in a database of about 100 tables. This User
> needs modify(Change structure of table) permission on a single table. User
> want to incorporate triggers into the table. Can someone suggest me the
> best
> way to grant permission for this.
>
> Thanks
> --
> ontario, canada
> =====================================================