A.) write the folloing SQL server permisions in a correcct order: 1. Database us

Question

A.) write the folloing SQL server permisions in a correcct order:

1. Database user level permissions

2. Database object level permissions

3. Server level permission, which includes login permissions

4. Schema level permissions

B.) If a SQL Server instance is setup with window authentication mode only, following accounts can't access the SQL Server engine

1. Domain accounts

2. Server admin accounts

3. SQL Server only login accounts including the SA account

4. Accounts created on the local machine

Explanation / Answer

A:

order is 3,1,4,2

database server> database >schema level> database object level

this will be like top to root

B.

Domain accounts, Server admin accounts can access.

Sql server login will not be in context and Local Machine accounts cannot because Windows mode is through kerboros authenticated (this is server side authentication),so local users cannot access.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.