![]() ![]() Logins provide a mechanism for users to connect to the SQL Server platform at the server level. Generally, the process used for providing access to SQL Server resources is to create the principals you need and then configure them with the necessary permissions to access specific securables. Together, these three types of components can help you protect a SQL Server environment and its data at every level, from the availability groups down to the individual database objects. For example, you can grant a Windows login (the principal) the ability to view data (the permission) in a specific database schema (the securable). Permissions: Types of access granted on a securable to a specific principal.Securables are the actual resources you’re trying to protect, whether at the server level (e.g., availability groups), database level (e.g., full-text catalog), or the schema level (e.g., table or function). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |