| Author |
Topic |
|
rajajetti
Starting Member
5 Posts |
 Posted - 2010-07-16 : 01:53:45
|
| Hi All,I need to create a user in SQL Server 2005 Express Edition. That user should have the permission for taking and restoring the backup of database alone. He shouldn't have the admin rights and he shouldn't access the other databases also.Is it possible. If it is kindly explain me how to do this.Thanks in advance.Regards |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rajajetti
Starting Member
5 Posts |
Posted - 2010-07-16 : 02:25:12
|
| Thank you so much for your reply. I did as you said but when i am trying restore the database its giving the error is "Cannot access the specified path or file on the server.Verify that you have the necessary security priviliges and that the path or file exists"Kindly help on this.Regards. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rajajetti
Starting Member
5 Posts |
Posted - 2010-07-16 : 02:57:48
|
| At the time of clicking add button in "Specify backup" window only i am getting the error. |
|
|
|
rajajetti
Starting Member
5 Posts |
Posted - 2010-07-16 : 03:02:16
|
| And any where can i need to give any permissions other than that "dbcreator" for user and any where for databse.Regards |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rajajetti
Starting Member
5 Posts |
Posted - 2010-07-16 : 04:43:20
|
| I tried with admin rights its working. I am using Express edition 2005,Is the problem with the version? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-07-16 : 13:46:41
|
| also check db_backupoperator |
|
|
|
|
Granting the permission to the user