Post reply

Permissions to specific function

  • July 16, 2009 at 6:23 am

    #136178

    Hello.

    I need to grant permissions to specific scalar function in specific database.

    How Can I deny execution from everyone except 3 specific users / logins?

    Thanks.

  • July 16, 2009 at 6:31 am

    #1025567

    Hi,

    The solution really depends on the security set up you apply.

    If the object is new and all logins (or groups) only have the permissions they need then you can just grant execute permissions on the object to the login(s) you require.

    GRANT EXECUTE ON TO

    That would probably be the simplest solution.

    Check out my blog http://www.sqlservercentral.com/articles/Best+Practices/61537/

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

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