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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  account permission

Author  Topic  songqh Starting Member 9 Posts Posted - 2001-08-13 : 21:00:27 Question: You are a memeber of your company's SQL server 7.0 sysadmin fixed server role, and you are also a member of the windows NT Managers group. Both your individual windows NT user account and the Managers group account were previously granted the SELECT,INSERT,UPDATE and DELETE permissions for the DEPARTMENT table in the EXCUTIVE database. Joan, another memeber of the sysadmin role, revokes the SELECT and INSERT permissions from the managers group and denies your user account the UPDATE and DELETE permissions DEPARTMENT table in the EXECUTIVE database. What are your resulting permissions for DEOARTMENT table in the EXECUTIVE database when log in to SQL server using your individual wiindows NT user account ? A. You can't select,insert,update or delete data in the DEOAARTMENT table. B. You can select,insert,update or delete data in the DEOAARTMENT table. C. You can only select and insert in the DEOAARTMENT table. D. You can update and delete data in the DEOAARTMENT table. Answer: B. why? i think the answer should be C, because update and delete permissions are denied. can anyone explain it for me? thanks.