tailieunhanh - Use Statement Permissions

Bản Tuyên Bố Quyền sử dụng cơ sở dữ liệu SQL Server có thể trở nên khá lớn và phức tạp. Điều quan trọng là kiểm soát số lượng và loại đối tượng mà được thêm vào một cơ sở dữ liệu SQL Server để cấu trúc của nó chỉ chứa những đối tượng có thực sự cần thiết cho hoạt động của cơ sở dữ liệu | Use Statement Permissions SQL Server databases can become quite large and complex. It is important to control the number and type of objects that are added to a SQL Server database so that its structure contains only those objects that are actually required for the database s operation. If object creation were not controlled users could build temporary tables views stored procedures and other database objects that would become permanent additions to the database. There s no easy way to tell whether a particular database object is required by some front-end applications making it difficult to remove these objects. I want to control unwanted and unneeded object proliferation in my databases. Without some kind of control users might unnecessarily complicate the database s structure by adding unwarranted objects. Technique You will employ statement permissions to permit or disallow users to execute SQL statements that modify the database structure. There are also statement permissions controlling SQL statements that back up the database and its log file. These statements include the following CREATE DATABASE. Creates a new database applicable only in the master database . CREATE DEFAULT. Establishes default values for columns in tables. CREATE FUNCTION. Creates a user-defined function that is saved as a Transact-SQL routine. CREATE PROCEDURE. Creates a stored procedure. CREATE RULE. Adds a rule to a column in a table. A rule specifies the acceptable values for the column. CREATE TABLE. Creates a new table within the database. CREATE VIEW. Adds a view to the database. BACKUP DATABASE. Backs up the entire database to removable media. BACKUP LOG. Backs up the database s log file to removable media. Although this security task has been discussed only from the perspective of limiting the user s ability to create database objects statement permissions are also a way to ensure that users who really need to modify the database structure are able to do so. Statement .