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
 =====================================================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
> =====================================================
 
No comments:
Post a Comment