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 |
|
p2bl
Yak Posting Veteran
54 Posts |
 Posted - 2002-12-16 : 01:05:16
|
| I have some important tables and views and store procedure,how can I deny drop to a special login?And how can I mark a view or storeprocedure as 'readonly',just like those in 'master' database?thanks a lot========================look! |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2002-12-16 : 02:12:38
|
quote:
I have some important tables and views and store procedure,how can I deny drop to a special login?And how can I mark a view or storeprocedure as 'readonly',just like those in 'master' database?thanks a lot========================look!
for denying permissoins on objects,go to enterprise manager expand the database,right click the stored procedure in the all tasksclick on [b] manage permissions[\b] here u get the interface for managing the permissions for the users.harshal. |
 |
|
|
p2bl
Yak Posting Veteran
54 Posts |
Posted - 2002-12-16 : 05:54:11
|
| but what I really want is to deny 'DROP' or 'ALTER'(which are not listed in the permission page) to an object,not 'select' or 'exec'.========================look! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-12-16 : 13:44:16
|
| Well how about you just don't give them the access to do it. You shouldn't just deny the permissions, but rather don't give them the permission. Are you trying to deny the permissions to someone who is part of the db_owner role in a database or a member of the system administrator role on the server? If so, you are going about this the wrong way. Don't give them this much access. Start with just giving them public access and then adding permissions on objects. |
|
|
|
p2bl
Yak Posting Veteran
54 Posts |
Posted - 2002-12-16 : 23:24:29
|
| Right as u have said.Thanks a lot!========================look! |
|
|
|
|
|
|
how to prevent an object from being dropped?