Re: User function permissions

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 09/16/05 

Date: Fri, 16 Sep 2005 06:20:24 -0600

Hi,

Give execute rights to function

grant exec on <func_name> TO user_name

Thanks
Hari
SQL Server MVP

"jaylou" <jaylou@discussions.microsoft.com> wrote in message
news:441CB642-3EBC-4ABE-970C-9158A822DC3D@microsoft.com...
> Hi All,
> I have apps that use user defined functions in SQL 2000. The DBA before
> me
> set all users and groups to SA or db_owners. As we all know SOX doesn't
> like
> that.
>
> Do I have to grant rights to the functions or can public execute a
> function?
> I have not seen any references to granting permissions to functions.
>
> TIA,
> Joe

Relevant Pages

  • Re: Sys SP
    ... other apps). ... Tibor Karaszi, SQL Server MVP ... "MAT" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Restore points available
    ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ... >> backup jobs so you can keep the size of the backup list down to a ... > Whoever had the brilliant idea of tacking DBA onto my job title should be ...
    (microsoft.public.sqlserver.server)
  • Re: is this bad?
    ... >> able to make an informed decision. ... >> Tibor Karaszi, SQL Server MVP ... >>> effect the any DBA would be very unhappy with this. ... >>> I am using a stored procedure to retrieve data for an asp.net datagrid ...
    (microsoft.public.sqlserver.programming)
  • Re: Transactio Log reader... ???
    ... Tibor Karaszi, SQL Server MVP ... "DBA" wrote in message ... >> Paul Ibison)SQL Server MVP) ...
    (microsoft.public.sqlserver.server)
  • Re: NO LOCK
    ... SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ... SQL Server MVP ... "DBA" wrote in message ... > This may sound dumb, but is there a way that I can do in SQL somthing like ...
    (microsoft.public.sqlserver.programming)