Re: Cross database granting

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

Date: Fri, 5 Mar 2004 16:13:04 +0200

Thanks for sticking with me so far.

I've decided to add a new user (and custom login)
to the master database.

But a new error occurs when I try to run the
procedure (logged in as that user):

Msg 50001, Level 1, State 50001
xpsql.cpp: Error 997 from GetProxyAccount on line 604

When I login as sa, the problem doesn't occur.
I'm using MSDE2000 SP3.

@@VERSION returns:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
 Dec 17 2002 14:22:05
 Copyright (c) 1988-2003 Microsoft Corporation
 Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 3)

Thanks
Chris

--------------------------------------
Chris Buys
Development
HAS Software (Pty) Ltd

"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:#BWfHjrAEHA.916@tk2msftngp13.phx.gbl...
> Creating a user in master will not increase in any way that a login's
> connection will default to the master database. There already is a guest
> user in master, meaning that all logins can access master.
>
> You could enable cross database chaining ownership (whatever it is called,
> there's a new security setting introduced in sp3 you need to enable - read
> about it in sp3 readme) and then have the same database owner for the two
> databases and the user in the app database should be able to execute
> xp_cmdshell implicitly if called from a proc in the app database.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "Chris Buys" <chris@h-a-s.co.za> wrote in message
> news:uJ11k1qAEHA.2800@tk2msftngp13.phx.gbl...
> > 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
> >
> >
> >

Relevant Pages

  • Re: Trouble granting access to user in MSDE-2000
    ... Have you tried adding ASPNET login as a user in master database? ...
    (microsoft.public.sqlserver.security)
  • Re: Cluster will not fail over.
    ... Senior Database Administrator ... >> As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... >> able to restore the master database. ... >> a cluster installation you'll have to revisit. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cross database granting
    ... connection will default to the master database. ... You could enable cross database chaining ownership (whatever it is called, ... > Chris Buys ... >>> the EXECUTE priviledge. ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger, alternative way to pass variable to trigger
    ... You don't have to execute the setUser command in the master database, ... create trigger trigger name ... to call stored procedure or execute sql commands and let it handle it the ... Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)
  • Re: Cross database granting
    ... enable cross-database chaining for your user database: ... > When I login as sa, ... > Chris Buys ... >> connection will default to the master database. ...
    (microsoft.public.sqlserver.programming)
Loading