TAILIEUCHUNG - Use Object Permissions

Quyền sử dụng đối tượng lúc này, bạn đã thêm SQL Server và đăng nhập tài khoản người dùng thành lập ở mỗi cơ sở dữ liệu trong SQL Server. Trong hầu hết trường hợp, bạn muốn hạn chế truy cập của người dùng để bàn, | Use Object Permissions At this point you have added SQL Server logins and established user accounts in each database within SQL Server. In most situations you want to restrict the user s access to tables views stored procedures and other objects within this database. This is done by setting permissions on these database objects. I do not want every user to have read write and update permissions on every table within the database. Otherwise unauthorized users are able to view data that they are not permitted to see. Often only certain users are permitted to add new records or to delete existing records in a database table. Without object permissions I have no way of controlling individual user access to the data within a database. Technique You ll use the Enterprise Manager dialog boxes to assign permissions on the objects within a database. SQL Server provides the following object permissions for tables views and stored procedures Select. Permission to issue SELECT statements against a table or view to retrieve data. Insert. Permission that allows the user to execute the INSERT statement to add new records to a table or view. Update. Permission that allows the UPDATE statement to run changing the data in a row of a table or view. Delete. Permission to run the DELETE statement and remove rows from a table or view. Execute. Permission that allows the user to run stored procedures and functions within the database. Steps A SQL Server database contains a wide variety of database objects such as tables views and stored procedures. A user account can be assigned specific permissions on each object in a SQL Server database. These permissions direct SQL Server to allow an account to run stored procedures view and update data that is contained in tables and perform other database operations. As you click on the individual object permissions the check box changes from empty to a green check mark to a red X as mentioned in the previous How-To. 1. Open Enterprise Manager

• Cơ sở dữ liệu
• công nghệ máy tính
• phần mềm
• kỹ thuật lập trình
• dữ liệu
• Use Object Permissions
• Phần cứng máy tính
• lắp ráp máy tính
• sửa chữa máy tính
• lỗi máy tính
• hệ thống mạch máy tính
• điện máy tính
• Tài liệu máy tính