Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Error while taking backup for a user not having sysadmin permission Expand / Collapse
Author
Message
Posted Thursday, May 2, 2013 8:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 5:11 AM
Points: 272, Visits: 1,756
Hi Hanshi
Yes, you are correct. I was knowing it that SSMS uses xp_fixeddrives. I have also included it in my msdn forum link.But I was not sure about it.
But if the query is able to take backup or if we give directly file name then backup works.So it is not a permission problem.Only problem is with how SSMS works. Also a small bug in SSMS!!
Post #1448829
Posted Thursday, May 2, 2013 8:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 12,963, Visits: 32,512
there are lots of other functionalities that SSMS assumes you must have sysadmin rights in order to perform actions;

most of the nodes in the Object explorer assume it, scripting of objects is one example i know of off the top of my head.

example: create a user with VIEW ANY DEFINITION and login as that user into SSMS. you'll get errors whenever you expand any nodes, when in theory they should be able to view it (that login can see the metadata via queries, of course.

CREATE LOGIN ViewAnyThing WITH PASSWORD = 'NotTheRealPassword';
GRANT VIEW ANY DEFINITION TO ViewAnyThing;



Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1448834
Posted Thursday, May 2, 2013 10:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 19, 2014 10:30 AM
Points: 322, Visits: 983
Under what account does the SQL server and SQL agent services run?

Those accounts must have modify access to the path.
Post #1448909
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse