Re: SQL 2005: non SA user create a job
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Fri, 18 Jan 2008 13:45:03 -0500
'carll' still needs to be made a user of msdb.
USE [msdb]
GO
CREATE USER [carll] FOR LOGIN [carll]
GO
RLF
<it@xxxxxxxxxxxxx> wrote in message
news:57cbf83c-c872-4ce9-8d31-ecf2e77d5788@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm trying to use the following but I'm getting an error:
statement:
(i am using the MSDB database)
exec sp_addrolemember N'SQLAgentOperatorRole', N'carll'
error:
user or role 'carll' does not exist in the database
The user is setup to login to SQL server.
.
- References:
- SQL 2005: non SA user create a job
- From: it
- Re: SQL 2005: non SA user create a job
- From: it
- SQL 2005: non SA user create a job
- Prev by Date: Re: SQL 2005: non SA user create a job
- Next by Date: Re: Rights for Linked Server
- Previous by thread: Re: SQL 2005: non SA user create a job
- Index(es):
Relevant Pages
|
|
