Page 95 - DCAP508_DATABASE_ADMINISTRATION

Unit 6: SQL Server Authentication

Notes
Tables and columns
Table-valued functions (Transact-SQL and CLR), and columns
Types
Views and columns
INSERT Synonyms
Tables and columns
Views and columns
DELETE Synonyms
Tables and columns
Views and columns
EXECUTE Procedures (Transact-SQL and CLR)
Scalar and aggregate functions (Transact-SQL and CLR)
Synonyms
CLR types
RECEIVE Service Broker queues
VIEW DEFINITION Procedures (Transact-SQL and CLR)
Service Broker queues
Scalar and aggregate functions (Transact-SQL and CLR)
Synonyms
Tables
Table-valued functions (Transact-SQL and CLR)
Views
ALTER Procedures (Transact-SQL and CLR)
Scalar and aggregate functions (Transact-SQL and CLR)
Service Broker queues
Tables
Table-valued functions (Transact-SQL and CLR)
Views
TAKE OWNERSHIP Procedures (Transact-SQL and CLR)
Scalar and aggregate functions (Transact-SQL and CLR)
Synonyms
Tables
Table-valued functions (Transact-SQL and CLR)
Views
CONTROL Procedures (Transact-SQL and CLR)
Scalar and aggregate functions (Transact-SQL and CLR)
Service Broker queues
Synonyms

6.2.2 Permissions Validation

After a user has been authenticated and allowed to log in to an instance of Microsoft® SQL
Server™, a separate user account is required in each database the user must access. Requiring
a user account in each database prevents users from connecting to an instance of SQL Server
and accessing all the databases on a server. For example, if a server contains a personnel
database and a recruiting database, users who should be able to access the recruiting database
but not the personnel database would have a user account created only in the recruiting
database.

LOVELY PROFESSIONAL UNIVERSITY 89