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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2007-09-27 : 02:38:31
|
| Hi thereWe have 1 database that using SQL2005 and as Domain Admin I couldn't get access to one of the VIEW. But some other guys (not sure which group he is on as yet) can access no problem.So I've setup my login as dbo of that database and still I couldn't get access to SELECT.Any ideas?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 00:12:20
|
| Check permission on that view to see if any deny permission there. |
 |
|
|
evjo
Starting Member
20 Posts |
Posted - 2007-09-29 : 22:56:09
|
| Are you a sysadmin on the box? being a domain admin doesn't necessarily make you a sysadmin in sql server.Whenever I see an old lady slip and fall on a wet sidewalk, my first instinct is to laugh. But then I think, what if I was an ant, and she fell on me. Then it wouldn't seem quite so funny. - Jack Handey |
|
|
|
|
|
|
SQLServer 2005 - Permission Issue