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 |
|
ProEdge
Yak Posting Veteran
64 Posts |
 Posted - 2007-06-22 : 14:07:06
|
| Hi, I'm using the Express version of SS2k5 and I'm running into a weird problem. When using management studio express, under the securables section of a user or database role, for example, you're giving the ability to add or remove objects. For some reason, the Remove button is always greyed out so I'm unable to remove an object. I have sysadmin privileges so I don't see why this is so. Is it possible that this is a feature only in a standard or developer's edition? Any help would be appreciated. Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-22 : 15:29:05
|
| You can't remove system objects. |
 |
|
|
ProEdge
Yak Posting Veteran
64 Posts |
Posted - 2007-06-22 : 15:32:01
|
quote:
Originally posted by rmiao
You can't remove system objects.
I'm not talking about system objects. These are user objects like tables, stored procs, etc. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-22 : 16:48:21
|
| You can revoke permission from those objects and close the properties, that will remove those objects from securables. |
|
|
|
ProEdge
Yak Posting Veteran
64 Posts |
Posted - 2007-06-22 : 16:57:23
|
quote:
Originally posted by rmiao
You can revoke permission from those objects and close the properties, that will remove those objects from securables.
You mean I have to write a revoke statement for each possible permission on the object? Could you provide an example of how you would do this? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-23 : 22:18:35
|
| You can do it in SSMS. |
|
|
|
|
|
|
Securables