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 |
|
pradeep_iete
Yak Posting Veteran
84 Posts |
 Posted - 2010-02-22 : 08:52:56
|
| Hi , Is it possible to have Login with folowing powers --> Able to see data but not modify it. --> Able to execute the dynamic views Thannks |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2010-02-22 : 13:26:11
|
| You need to create a ROLE with requested permissions and assign it to User.- Grant SELECT Permissions on all table(s) / Deny update/alter/Insert/delete permissions- Grant to EXEC permissions on DMV and DENY etc etcWith RegardsSR |
 |
|
|
|
|
|
Server Credentials