Administrating a Database Flashcards
______, like every other aspect of the database
project, must be carefully designed, implemented,
and tested.
Because ______may affect the execution of some
procedures, it must be taken into account when
the project code is being developed.
Security
A ______is used to grant an entity (such as a
user access) to an object (such as another user or
a database).
permission
In SQL Server, the security model is based on what
is referred to as “_______”.
securables
A ____ or ______is the process by which an
individual’s access to a computer system is
controlled by identification of that user using
credentials provided by that user.
login or logon
The most common login method is using a
______and ______
username and password
A _______ is a logical representation of
a person within a electronic system.
user account
A security system that requires two distinct forms of identification in order to access something
Two-Factor Authentication(2FA)
SERVER-LEVEL SECURITY:
The three different methods for which a user can
be initially identified include:(3)
– Windows user login
– Membership in a Windows user group
– SQL Server-specific login (if the server uses
mixed-mode security)
Each object’s permission is assigned
through either _____, ______, or _____
user login permissions
Granting
Revoking
Denying
______ means the user can access
the object
Grant permission
______ removes the permission
assigned, regardless of whether it’s deny or
grant.
Revoke permission
______ overrides a grant
permission
Deny permission
There are three different types of accounts
which are available for the SQL Server
service account(3)
- Local user account
– Local system account
–Domain user account
_______is the act of establishing or
confirming a user or system identity.
Authentication
_________ mode is superior to
mixed mode because users don’t need to
learn yet another password and because it
leverages the security design of the network.
Windows Authentication
SQL servers also support _____ _____, which
allows you to connect to the SQL server using
Windows authentication or SQL Server
authentication.
mixed mode
- A SQL Server login account and related passwords
are defined on the ____ ____ and are not related
to Active Directory or Windows accounts
SQL server
Associated with SQL authentication is the ___ _______, the built-in SQL administrator account
associated with SQL authentication.
sa account
SQL Server includes fixed, predefined server roles:(8)
– Bulkadmin
– Dbcreator
– Diskadmin
– Processadmin
– Securityadmin
– Serveradmin
– Setupadmin
– Sysadmin
Any user who wishes to access a database but has
not been declared a user within the database will
automatically be granted the user privileges of the
___________.
guest user
The ___ _____ account is not actually created
when a database is created. It must be specifically
added in through the SQL Server Management
Studio interface or through a Transact-SQL
statement.
uest user
___ ______ are the permissions that allow
a user to act on the database objects (such as
tables, stored procedures, and views):
Object permissions
Examples of Object Permissions(6)
– Select
– Insert
– Update
– Delete
– DRI (References)
– Execute
In SQL Server databases, users often access
data by going through one or several objects.
*____ ______ apply to views, stored
procedures, and user-defined functions.
Ownership Chains
