Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2007-02-01 : 15:57:11
|
| I want to create a user with dbreader, dbwriter and ability to backup a database.I was able to assign the user with dbreader and dbwriter, I do not know how to assign backup role to the user.The user should have only dbreader, dbwriter and backup database privilegesIs there anyway to do it.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-01 : 16:07:56
|
| You can use the db_backupoperator database role. It does give them a little more than just backup though, but there's not a way around that.Tara Kizer |
 |
|
|
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2007-02-01 : 16:28:22
|
| I added the user to the db_backupoperator but I get the following errorerror 229: execute permission denied on object 'sp_MSSharedFixedDisk', database 'master', owner 'dbo'I searched in microsoft for this error, they suggest a work around for this by adding user to sysadmin role - which defeats my purposehttp://support.microsoft.com/kb/323249any ideas??Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-01 : 16:32:38
|
| Can the user run BACKUP commands though in Query Analyzer?Tara Kizer |
|
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-02-01 : 20:27:40
|
| 'sp_MSSharedFixedDisk' procedure calls xp_availablemedia extended procedure...By default public role is granted to execute 'sp_MSSharedFixedDisk' procedure...I think some one removed execute permissions to public role on this procedure for security lock down...Try granting the permission to public or the specific user for 'sp_MSSharedFixedDisk' procedure ...MohammedU |
|
|
|
scelamko
Constraint Violating Yak Guru
309 Posts |
Posted - 2007-02-05 : 09:38:47
|
quote:
Originally posted by MohammedU
'sp_MSSharedFixedDisk' procedure calls xp_availablemedia extended procedure...By default public role is granted to execute 'sp_MSSharedFixedDisk' procedure...I think some one removed execute permissions to public role on this procedure for security lock down...Try granting the permission to public or the specific user for 'sp_MSSharedFixedDisk' procedure ...MohammedU
Yepp this did the trick.Thanks |
|
|
|
|
|
|
Backup role