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 |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2008-01-21 : 16:31:15
|
| I have a Database called DATAMART Login name called ARCTEC and assigned to schema ARCTEC. Views are ARCTEC.myview1 , ARCTEC.myview2 When i use login ARCTEC I can amend the view. Im trying to prevent this and only have the login beable to run it. I right click on the ARCTEC.myview1 permissions and keep adding ARCTEC and clicking on deny and i still can login and amend the view. What am doing wrong. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 16:40:45
|
| Try move user ARCTEC to other schema. |
 |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-22 : 12:10:17
|
| Got it working i changed the USER ARCTEC back to dbo and it worked.Thanks |
|
|
|
|
|
|
Not be able to change the view