Post reply

Permissions to specific function

  • July 16, 2009 at 6:24 am

    #212449

    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 7:27 am

    #1025625

    you can give permission to execute function to three user.

  • July 16, 2009 at 7:36 am

    #1025635

    If you don't give permissions, they don't have it. That's the way SQL Server works. So what you want to do is avoid the DENY and just GRANT the permissions to the ones who need it. The best way to handle this:

    - Create a role to have the appropriate permissions on the function (and on anything else).

    - Grant that role the appropriate permissions.

    - Make everybody except those three a member of that role (this is best done through the use of Windows groups).

    K. Brian Kelley
    @kbriankelley

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

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