October 13, 2009 at 11:40 am
sql server 2005
select * from fn_my_permissions(null,null)
server CONNECT SQL
server SHUTDOWN
server CREATE ENDPOINT
server CREATE ANY DATABASE
server ALTER ANY LOGIN
server ALTER ANY CREDENTIAL
server ALTER ANY ENDPOINT
server ALTER ANY LINKED SERVER
server ALTER ANY CONNECTION
server ALTER ANY DATABASE
server ALTER RESOURCES
server ALTER SETTINGS
server ALTER TRACE
server ADMINISTER BULK OPERATIONS
server AUTHENTICATE SERVER
server EXTERNAL ACCESS ASSEMBLY
server VIEW ANY DATABASE
server VIEW ANY DEFINITION
server VIEW SERVER STATE
server CREATE DDL EVENT NOTIFICATION
server CREATE TRACE EVENT NOTIFICATION
server ALTER ANY EVENT NOTIFICATION
server ALTER SERVER STATE
server UNSAFE ASSEMBLY
server CONTROL SERVER
I guess the above are my server level permissions .
I am trying to run an SSIS package which creates a text file . I am trying to automate this SSIS
by trying to run in every 5 min using Sql Agent jobs . But it keeps failing.
The process is :
Creating a credential,
Creating a proxy,
Creating the job and then running the SSIS package using that job
Thanks
October 13, 2009 at 1:37 pm
can you look at job history?.any error message there.
October 13, 2009 at 3:01 pm
Does the proxy user have access to the path. Does it have sufficent rights in the File system to do what you want?
Try to run the SSIS package on the server while logged in as that user, it may give you more detail.
CEWII
October 20, 2009 at 4:16 pm
How do I check if the proxy user has the necessary permissions / privileges
Thanks
October 20, 2009 at 4:47 pm
1. Determine what the proxy users name is domain\username
2. Right click on file you want to check.
3. Go to security tab.
4. See what users have rights to that file.
One issue, much of what should be listed there will be user roles.
You need to find out what roles the proxy user is in. I can't easily explain that. your notworking group should be able to tell you though..
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply