SQL Server Performance

server level exec permissions on specific function

Discussion in 'SQL Server 2005 General DBA Questions' started by sdavidchuk, Jun 16, 2008.

  1. sdavidchuk New Member

    Hello Everyone,
    windows 2003 enterpr, sql 2005 sp2
    we have 30 dbs, and every one of them have the same Scalar-valued Function.
    Also, a windows auth login account that have to have a right to exec that function within every database
    Question: i can make this function global by creating it in a master db or i can go to every single database and grant perm
    to exec that function for this windows login.....
    is there any other way to grant function exec permission for this specific user on the server level?
    so it can be done once, and not for every single database that we have
    thanks
  2. ghemant Moderator

    Hi,
    IMO you can have two option add this function to master database, or you can create role ->add login(s) -> grant permission

Share This Page