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 |
|
Arun.G
Yak Posting Veteran
81 Posts |
 Posted - 2010-07-26 : 03:19:06
|
| i have one login as 'aspdev' in my sqlserver 2008 databasethey should only able to view all the sp's and tables,view,functionsand not able to do alter,update,delete,drop on all tables , sp's views,functionswhat to do? |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-26 : 04:56:13
|
| DENY SELECT,INSERT,UPDATE,DELETE,VIEW ON [SchemaName].[aspdev]Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
 |
|
|
Arun.G
Yak Posting Veteran
81 Posts |
Posted - 2010-07-26 : 05:09:03
|
| its giving error onlyi want to deny that permisionns to whole database not for particular schema |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-26 : 05:12:27
|
| What is the error?Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
Arun.G
Yak Posting Veteran
81 Posts |
Posted - 2010-07-26 : 05:45:23
|
| Msg 102, Level 15, State 1, Line 1Incorrect syntax near 'VIEW'. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-07-26 : 05:53:22
|
| If you want that the particular user should not be able to do anything on the database then dont map that user to that particulare DB.Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless. PBUH |
|
|
|
|
|
|
|
|
revoke permissions