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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2005-01-12 : 16:36:38
|
| I have an application that takes given parameter like an SSN and creates a complete database from our 80GB database.This is how it works, it takes the empty schema, creates a database on a server, pumps all data from a source(80GB) database and puts it into this small database, backs up the small database as a flat .bak file and drops the small database after it is done.The problem is that we have to now give other users permission to use this tool. but we cannot give the SA password(no surprises there).So what I did was that made a user called xyz and made it a member of DBCreater Server Role and DBO of the large database. This application does not work.But if I add this XYZ in SysAdmin role ,it works.Is there a way around this? |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2005-01-12 : 17:01:51
|
edit and opps... missed this part quote:
But if I add this XYZ in SysAdmin role ,it works.
which rendered my first suggestion useless (and don't have a second right now)I wish someone would start an Official XML Rant Thread. |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2005-01-12 : 19:09:42
|
many administrative scripts usexp_cmdshell quote:
By default, only members of the sysadmin fixed server role can execute this extended stored procedure
sp_OACreatequote:
Only members of the sysadmin fixed server role can execute sp_OACreate.
hopefully the administrative scripts are available outside the application so you can seeI wish someone would start an Official XML Rant Thread. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-01-12 : 19:11:39
|
| We'll need to know what things the tool is calling in order to tell you what permissions it will need.Tara |
|
|
|
|
|
|
DBCreator and SYSAdmin