Post reply

Customizing statement permissions using GRANT

  • July 3, 2008 at 9:23 am

    #72347

    Hi,

    Does anybody know if it is possible in SQL Server 2000 to give a user the following specific statement permissions using the GRANT statement?

    SELECT permission on any object

    DELETE permission on any object

    INSERT permission on any object

    UPDATE permission on any object

    ALTER TABLE

    TRUNCATE TABLE

  • July 3, 2008 at 10:58 am

    #838002

    Yes you can. Just right click the concerned object or user under databases and there you will see bunch of permissions tht can be assigned to a user.

    Manu

  • July 3, 2008 at 10:58 am

    #838005

    SELECT, DELETE, INSERT, UPDATE may be granted to individuals but ALTER TABLE and TRUNCATE TABLE are only available for members of the db_owner, db_ddladmin, and sysadmin roles and the table owner.

    Greg

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply