Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Thursday, November 17, 2016 12:58 AM
Points: 278, Visits: 1,798
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 @ 9:41 PM
Points: 14,556, Visits: 38,433
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

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
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: Saturday, February 28, 2015 10:12 AM
Points: 329, Visits: 1,019
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