Re: grant permission on system sps,xps

From: Stephen Dybing [MSFT] (stephd_at_online.microsoft.com)
Date: 05/22/03 

Date: Thu, 22 May 2003 09:54:31 -0700

Sure, select the Stored Procedures or Extended Stored Procedures container
in the proper database, right click on the object you wish to grant
permissions to, select Properties, and click the Permissions button. 

-- 
Hope this helps,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Martin de vroom" <martindevroom@hotmail.com> wrote in message
news:ep$%23kQPHDHA.2964@tk2msftngp13.phx.gbl...
> Hi,
>
> I have just created a user in my sql server 2000 ent edition sp3.
>
> The login uses sql authentication.
>
> I have been able to add certain statement permissions by right clicking on
> the database node in question in EM and selecting the correct permission.
>
> I have also given them access to a few user defined sp's.
>
> My question is how do I give the user access to system sp's and extended
> sp's. Can I do this thought EM or do i have to script it via query
analyser.
>
> any help is appreciated.
>
> martin.
>
>

Relevant Pages

  • Re: Help understanding Stored proc Level Secuirty?
    ... Jasper Smith (SQL Server MVP) ... I set permissions to my Stored Procedures, ... Access to stored procs fail ...
    (microsoft.public.sqlserver.security)
  • Re: Securing Stored Procedures from being seen
    ... PERMISSIONS works for the current user, whoever he may be, and however his rights were granted. ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... see the names of any stored procedures to which he has no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Newbie on permissions: ADO.NET, C++.NET, SQL SERVER 2005 EXPRESS, Visual Studio 2005
    ... Permissions are per logins and users. ... permissions can be granted through stored procedures, ... an extent a trivial question since I can do programming in VS as ... "Administrator" (it's annoying to switch users using Windows XP Pro, ...
    (comp.databases.ms-sqlserver)
  • Re: Newbie: Restrict user account access to stored procedures
    ... You can deny users permissions to directly access tables and views by adding ... SQL Server does not, to the best of my knowledge, support any database role, ... stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: permissions required for executing CDOSys stored procedures
    ... sysadmin and who has not been granted specific execute permissions on the ... I don't know what version of SQL Server you are using, ... stored procedures within the database that call the sp_OACreate & ... Apparently only members of the sysadmin role can ...
    (microsoft.public.sqlserver.security)