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 |
|
sachinbutala
Starting Member
4 Posts |
 Posted - 2004-04-16 : 08:13:20
|
| Hi,1. we want to restrict database list in Enterprise manager. i mean if user 'A' is logged in then he can see only database 'A' or which related with him. ( or can we restrict it to some limited numbers )2. Is there any way to restrict user from changing database maxsize and minsize . (user is possing DB_OWNER for his database ) |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-04-16 : 09:14:34
|
| 1. can't do....it's far better not to show/give him/her EM in the first place....QA is more than enough for users to have....and is a far better tool.2. stop the user acting as dbo or dba. |
 |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-04-16 : 10:03:15
|
| 1. SQL Server can be accessed by what seems like everything under the sun. From Excel to Access to Word. You name it. Its better to properly secure your SQL Server with proper permissions than to secure it by obscurity.-JonJust a starting member. |
|
|
|
|
|
|
Enterprise Manager