What are roles and how are they used in database security and permissions? Provide an example of a predefine server role.
What will be an ideal response?
A role groups together permissions on different database objects. A role can be granted to an individual user, known as a member in the context of the role, and that user will inherit the permissions granted to the role. Roles should be used whenever possible to manage permissions for groups of database users with similar access needs. SQL Server 2012 has several predefined roles at both the server and database level. An example of a server role is the sysadmin role, which can perform any function on the database server. An example of a database role is the db_owner role, which can perform any function for an individual database. Roles can also be used to model a business function to differentiate different access levels that groups of users need at a granular level.
You might also like to view...
Which statement is false?
a. A linked list is a linear collection of self-referential class objects called nodes connected by reference links. b. A linked list is appropriate when the number of data elements to be represented in the data structure is unpredictable. c. A linked list is a fixed-size data structure. d. By convention, the link reference in the last node of a list is set to null to mark the end of the list.
The ________ displays when you start PowerPoint 2016
Fill in the blank(s) with correct word
You can undo a table property change by pressing the ____ keys.
A. CTRL+Z B. CTRL+P C. CTRL+S D. CTRL+X
The SDLC documentation is everything about software development including the code.
Answer the following statement true (T) or false (F)