Re: Cross database granting

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 13:17:26 +0100

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: Mismatch between sysaltfiles and sysaltfiles
    ... It sound a bit scary to me, so I'd open a case with MS support to make sure that ... Tibor Karaszi, SQL Server MVP ... > sysaltfiles table in the master database for a datafile ...
    (microsoft.public.sqlserver.server)
  • Re: Execute the results of a query
    ... DECLARE StoredProcedureList CURSOR ... SELECT 'GRANT EXEC ON ' + ... FETCH NEXT FROM StoredProcedureList INTO @sqlstmt ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: can no longer add new logins
    ... > Seems like the transaction log of the Master database is not available - ... Then restore the master database from the last valid backup. ... > Dejan Sarka, SQL Server MVP ... and all of a sudden I can't add new logins. ...
    (microsoft.public.sqlserver.security)
  • Re: No ISSQLROLE column in sysusers?
    ... The other option involves rebuilding the master database with a ... Jacco Schalkwijk ... SQL Server MVP ... "James Hunter Ross" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Master Database is corrupted.
    ... rebuild the master database using rebuildm.exe. ... SQL Server MVP ... > - When I check the logs in the SQLServer folder, ...
    (microsoft.public.sqlserver.msde)
Loading