Post reply

Execeute As

  • September 30, 2008 at 11:18 pm

    #131567

    I need Help Regarding

    Execeute AS

    I have Read in BOL

    --------------------

    ****************************************

    SELF

    EXECUTE AS SELF is equivalent to EXECUTE AS user_name, where the specified user is the person creating or altering the module.

    Means Owner Of Module

    **************************************************

    OWNER

    Specifies the statements inside the module executes in the context of the current owner of the module.

    Means Again Owner

    --------------------------------

    It Means Owner and Self is the same

    Please Clarify this to me.

    Manish Arora

  • October 1, 2008 at 10:17 am

    #879612

    It means they're the same user if the user modifying the module is the current owner of module. You don't have own a module to modify it.

    For example: stored procedure SELPROC is owned by dbo which is mapped to the sa login. Another user who is a member of the db_ddladmin can modify the stored procedure, but isn't the owner.

    Greg

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

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