Sql Server 7 – Security, Exam Questions & Answers, 100% Accurate. VERIFIED.

Sql Server 7 – Security, Exam Questions & Answers, 100% Accurate. VERIFIED. 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 3 types of database roles--1. fixed 2. custom