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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-17 : 16:56:19
|
Vivaldi writes "Well,
I have come across an interesting design issue. I am attempting to construct a web enabled administration system for sql server 7.0. The issues are this: The users have very private data they want no one else to see. This data needs to be protected, even from a general SA. So, invoking a create database script is simple with ASP & an SP I assume, but how do I assign SA rights programmaticaly.
A possibility would be to have a generic SA and have the user change it so they have all the exclusive rights to that db. Using ASP, I would need to store the connection string for the user in a diff't database, along with logon information. This "public" database info would be encrypted for more security, but, is it possible to change the SA without using Enterprise Manager? I have dug around, but nothing has come up yet.
OS will either be nt4/latest sp or win2k os.
Thanks for your time.
Vivaldi" |
|
|
|
|
|
Changing SA, programaticaly