select all true statements select one or more: in sql server, permissions cannot be dropped from the special guest database user database users can be assigned to database roles and application roles sql server has a nested hierarchy of scope for all securables in sql server, permissions link principals to securables if sql server auditing is enabled, then the sql server instance will always shutdown immediately if logging cannot occur in sql server, a database user cannot exist without an associated sql login a security principal in sql server can be a server role, login, database user, database role or application role

Respuesta :

The resources to which the SQL Server Database Engine authorization system controls access are known as securables. A table is a securable, for instance.

Some securables can contain other securables, forming nested hierarchies known as "scopes" that can be protected in and of themselves. Server, database, and schema are the secure scopes. A principal is the entity that is granted authorization to use a securable. Users of databases and logins are the two most popular principals. Permissions, as well as attaching logins and users to roles with access, are used to control access to secure items. To learn more about managing permissions, The ability to execute a specific type of SQL statement, access an item owned by another user, or execute a PL/SQL package are all examples of user privileges.

Learn more about permission here-

https://brainly.com/question/13146880

#SPJ4