Re: permissions to some master SP's

gv,

EXECUTE permissions will allow your users to use the stored procedures,
although I cannot personally comment on the use of the replication stored
procedures and whether other rights are also needed. (For example, some
master and msdb stored procedures also include additional security checks or
additional filtering internally.)

The Books Online will often detail security requirements for system stored
procedures. For example:

Members of the sysadmin fixed server role or the db_owner fixed database
role can execute sp_repldone.

RLF


"gv" <viator.gerry@xxxxxxxxx> wrote in message
news:ODUcgFJpIHA.4928@xxxxxxxxxxxxxxxxxxxxxxx
Hi all,

I have a user that is owner of a replicated database and
they need permissions for some of the master database
Stored Procedures.
Example: sp_MS_replication_installed

What permissions would I need to give for those SP's?

thanks
gv



.

Relevant Pages

  • Re: Execute Persmission denied on object sp_OACreate
    ... SQL Server doesn't check permissions on indirectly referenced objects as ... You can prevent ad-hoc execution of powerful master database procs while ... >I have a user who has execute permissions on a store procedure in a>database> which in turns executes 4 stored procedures in the master database. ...
    (microsoft.public.sqlserver.security)
  • Re: Security: Accessing data in another db
    ... If your objects are owned by 'dbo', the database owners need to be the same ... those users that have permissions to create dbo-owned objects. ... which only has execute permissions on the stored procedures. ... > permissions from AppUser and then grants execute permissions for AppUser ...
    (microsoft.public.sqlserver.security)
  • Re: Help with using bits in an integer
    ... Is your database schema already decided? ... and I found myself becomming tied up in knots with my stored procedures. ... Much better to store this information in a database table ... a permissions bit, you want some number or some other data ...
    (microsoft.public.dotnet.languages.vb)
  • Re: application roles
    ... The best way is to take advantage of parameterized stored procedures, ... stored procedures and denying all permissions to the base tables to ... >What is the recommended approach to prevent users from accessing database ... >> your client code. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: permissions with sql server tables and access
    ... >>maintainable permissions on my tables, views, etc. ... >>access to my database. ... Only views and stored procedures can be used. ...
    (microsoft.public.sqlserver.security)