October 13, 2009 at 11:40 am
sql server 2005
select * from fn_my_permissions(null,null)
serverCONNECT SQL
serverSHUTDOWN
serverCREATE ENDPOINT
serverCREATE ANY DATABASE
serverALTER ANY LOGIN
serverALTER ANY CREDENTIAL
serverALTER ANY ENDPOINT
serverALTER ANY LINKED SERVER
serverALTER ANY CONNECTION
serverALTER ANY DATABASE
serverALTER RESOURCES
serverALTER SETTINGS
serverALTER TRACE
serverADMINISTER BULK OPERATIONS
serverAUTHENTICATE SERVER
serverEXTERNAL ACCESS ASSEMBLY
serverVIEW ANY DATABASE
serverVIEW ANY DEFINITION
serverVIEW SERVER STATE
serverCREATE DDL EVENT NOTIFICATION
serverCREATE TRACE EVENT NOTIFICATION
serverALTER ANY EVENT NOTIFICATION
serverALTER SERVER STATE
serverUNSAFE ASSEMBLY
serverCONTROL 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