How is a user granted permission to access a database?

What will be an ideal response?


Other than members of the sysadmin fixed server role, a SQL Server login may not access a database directly or be granted permissions to any of the underlying database objects because a SQL Server login is a server-level principal. To access a database, the SQL Server login must first be mapped to a database user, which is a database-level security principal.

Computer Science & Information Technology

You might also like to view...

To successfully ____________ the contents of two variables, we need a third variable that can serve as a temporary storage location.

a. copy b. exchange c. reference d. remove

Computer Science & Information Technology

The shortcut key ________ can be used to paste text

Fill in the blank(s) with correct word

Computer Science & Information Technology

Once cells have been merged they cannot be unmerged

Indicate whether the statement is true or false

Computer Science & Information Technology

In Windows 10, Firefox is the default search app.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology