Viewing 5 posts - 1 through 5 (of 5 total)
Yeah, the user is not a member of the sysadmin server role.
The person is admin on the local box for his instance of sql server but not on the domain.
June 7, 2006 at 7:54 am
By sysadmins did u mean securityadmin which is one of the server roles?
June 6, 2006 at 3:35 pm
Nope, the user is not a member of server roles. I made sure of that.
June 6, 2006 at 3:31 pm
Nope there are no roles granting access to the user, infact there s a deny on the user, evenso it still doesnt work. Th user is not in the db_owner...
June 6, 2006 at 12:34 pm
I used the command
DENY SELECT, INSERT, UPDATE ON TABLENAME TO USERNAME
The Deny permission doesnt work at all, i mean the user is able to select the requested data, apart...
June 6, 2006 at 10:56 am
Viewing 5 posts - 1 through 5 (of 5 total)