Re: Cross database granting

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Chris Buys (chris_at_h-a-s.co.za)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 14:28:15 +0200

Can I achieve the same effect without creating a user
for the master database? I don't want the user to inadvertently
default to the master database.

--------------------------------------
Chris Buys
Development

HAS Software (Pty) Ltd

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:#jJEUvqAEHA.220@TK2MSFTNGP09.phx.gbl...
> Just create a user in the master database for your login and then grant
EXEC
> permissions.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "Chris Buys" <chris@h-a-s.co.za> wrote in message
> news:e1c6jHqAEHA.1420@TK2MSFTNGP11.phx.gbl...
> > Hi everybody.
> >
> > I'm using MSDE2000 and I want to use the 'xp_cmdshell' when I'm not
> > logged in as the system administrator.
> > This call will be implemented in a stored procedure and will call an
> > executable
> > on the servermachine that returns some data (not relevant to the post).
> >
> > The problem is, is that I can't seem to GRANT the user I'm logging in as
> > the EXECUTE priviledge. The user is not in the master database's user
> list.
> >
> > Can any one please give my a code sample to establish this link?
> >
> > Thanks in advance
> > Chris
> >
> > --------------------------------------
> > Chris Buys
> > Development
> > HAS Software (Pty) Ltd
> >
> >
>
>

Relevant Pages

  • Re: Stored Procedures in the Master Database
    ... I tried qualifying the grant ... >If you are indeed in the master database when you run ... >> I have a stored procedure that I want to make available ... >> When I try to execute the stored procedure from another ...
    (microsoft.public.sqlserver.security)
  • Re: Stored Procedures in the Master Database
    ... If you are indeed in the master database when you run this GRANT, ... GRANT EXECUTE ON owner_name.proc_name TO public ... > I have a stored procedure that I want to make available to ...
    (microsoft.public.sqlserver.security)