SQL Server Learning-Basic management

The 1th Chapter Basic Management

1.1 Security and Permissions

1. Login name

Log on to the DB instance. Only the database instance can be logged on, but the login does not necessarily have access to the database.

a valid login account only indicates that the account has passed NT authentication or SQL authentication, but does not indicate that it can perform certain operations on the library data or objects. So a login account is always corresponding to one or more database user accounts. This will allow access to the database.

For example, the SA login account is associated with each number of user dbo .

2. Database user name

The user name of a single database, which person can access which database. User access to the database, manipulation is controlled by the database user. And the database user is database-based. Two different databases can have the same database user account.

3. Database Roles

Predefined database roles: pre-defined database roles cannot be changed to primary

4. Application Roles

5. Server Role

Roles that have fixed permissions depending on the application. When the server role is assigned to the login, it has the appropriate permissions for the database operation. That is, the server role automatically makes the login and database user mappings, and gives the appropriate database users the appropriate database permissions.

6. Architecture

that is, the container for the database. Similar to opening namespaces in software. The server name . The database name . The schema name . The name of the object, which is the qualified name of a complete Table object.

Previously, the user's default user name was used as the schema name. If you delete the user, then the user should be the following database, the table should be deleted. Now you don't have to. This is the qualified name of the old-fashioned table: server name . The database name . User name . Object Name

This article is from the "Network Line World" blog, please make sure to keep this source http://kuangkuang.blog.51cto.com/838/1698998

SQL Server Learning-Basic management