kelaram
 |
| 01/24/2002 12:21 AM |
 Quote
 Reply
 Alert
|
| Hello all: Trying to find how one can implement a WEB HOSTING level SQL SERVER. Means where a SHARED SQL DB is given for each hosted domain in shared hosting.
1) Running MS SQL SERVER 2000, SP2 on WINDOWS 2000 Server, SP 2
2) I have implemented the CHECKLIST as on this site
3) Running MIXED mode Authentication
4) Each DB has its own “user” and sp_changedbowner ‘this-db-user’. So other users can not see his DB
Problem?:
As I want the USER to have DBO access for THIS DB only, right now they can still change the SIZE of DB and TRANSECTION LOG. I want ot stop this as we selling based on SPACE.
Any help will be appreciated.
kelaram |
|
|
|
|
Chip Andrews
|
| 01/28/2002 3:49 PM |
Quote
Reply
Alert
|
| Try looking into the other db roles such as ddladmin. It is probably not necessary to make the users a dbo but rather give them just enough rights to meet your requirements. |
|
|
|
|
fatih
|
| 03/19/2002 2:53 AM |
Quote
Reply
Alert
|
| Hi, i am working on same problem.. :)
how can you prevent users to see other databases at Enterprise Manager. via EM user can see db names but can't reach its content .
|
|
|
|
|
shrenik
|
| 11/29/2002 6:37 AM |
Quote
Reply
Alert
|
| hi all,
Even I am also looking for solution on the same problem.
The present setup which is based on SQL Server 7.0, gives each user db_owner role membership for the database created for him.
One thing that i am not able to figure out is because of what that dbo is not allowed to change the size of data and log files (quota) along with other database properties. i m trying to find out and implement same on SQL Server 2000.
If anyone you can help me, I will be highly obliged.
Kindly revert back to me at shrenik.s@directi.com.
Thanking you in advance.
Shrenik. |
|
|
|
|