Results 1 to 6 of 6
  1. #1
    Join Date
    May 2009
    Posts
    4

    Unanswered: Permissions to specific function

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Look up GRANT, REVOKE and DENY.
    Also use groups, rather than assign permissions to specific users.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    May 2009
    Posts
    4

    How to set a group?

    And how to set group's permissions for function?

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    GRANT EXECUTE ON dbo.myFunction TO myGroupName
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    GRANT EXECUTE ON function_name TO group_name
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  6. #6
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Apologies - I've used the term groups when I meant roles....
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •