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 |
|
lio2007
Starting Member
8 Posts |
 Posted - 2007-12-12 : 13:58:09
|
| Hi,How can I prevent a colleage to delete tables in a specific database.Yes he has access to Enterprise Manager. We would like to allow him read only to the live databases.Is this possible? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
lio2007
Starting Member
8 Posts |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-12 : 16:43:07
|
quote:
Originally posted by lio2007
Shouldn't it be denydatawriter? What happens if this user is administrator will the role overwrite the administrator?
Datareader Access as suggested originally would limit that user's permissions to read only on the dataset, provided that user is not already an sa or dbo on the specificed database.If the user is an administrator, one would hope they are smart enough not to delete the table in the first place. Maybe the person shouldn't be an admin if that is a concern.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-12 : 16:44:51
|
quote:
Originally posted by lio2007
Shouldn't it be denydatawriter? What happens if this user is administrator will the role overwrite the administrator?
If they are a sysadmin, then they can just remove the denydatawriter role.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Prevent user from deleting tables