Sql Server 7 - Security – Locking. Questions & answers, 100% Accurate. Rated A+

Sql Server 7 - Security – Locking. Questions & answers, 100% Accurate. Rated A+ what are statement permissions?--create statements: CREATE TABLE, CREATE VIEW BACKUP DB, etc. what are object permissions?--select, insert, update, delete, reference, excecute. example: revoke select on authors to [user]. fixed database role: public--default permissions–– all users are members of the public role. fixed database role: db_denydatawriter--memebers of this role cannot make any data modifications. fixed database role: db_denydatareader--members of this role cannot read data. fixed database role: db_securityadmin--emmbers can add and remove users from roles and manage statement and object permissions. fixed database role: db_ddladmin--members can issue ddl commands. doesn't allow viewing fixed database role: db_datawriter--members can modify and delete data fixed database role: db_datareader--members can read data from all tables fixed database role: db_owner--members can do all of the things of all other roles + some admin stuff