Technology of SQL Server database (97)
Tuesday, March 03, 2009 by rain
14.4.1 attributive manages brief introduction
User after logging onto SQL Server,Date of its safety Zhang (user Zhang date) the limits of authority that the NT group with attributive place or part place are granted decided this user can is opposite what database object carries out which to plant operation and can visit, revise what data.In the attributive that two kinds of types include in SQL Server,Namely object attributive and statement attributive.
(1) object attributive
Object attributive always is in the light of process of watch, view, memory character,It decided to be able to execute what operation to process of watch, view, memory (like UPDATE, DELETE, INSERT, EXECUTE) .If the user wants to undertake to some object,operate,The limits of authority that its must have corresponding operation.For example,When the user should revise the data in the watch successfully,Criterion premise condition is the UPDATE limits of authority that he has been granted to express.
The is aimed at it operation exemple that does not differ with the object support of the type,If cannot carry out EXECUTE to expressing an object,operate.If express 14-1 place to show,the operation lists the likelihood that we will be aimed at all sorts of objects:
Notice:REFERENCE admissibility is in statement of GRANT, DENY, REVOKE to external key consults a data is inserted in the watch.
(2) statement attributive
Statement attributive basically shows whether the user has attributive to carry out some statement,These statements are a few operations that have administrative sex normally,If establish procedure of database, watch, memory,wait.Although this kind of statement still is included be like,have an operation (CREATE) object,But before these objects are carrying out this statement do not be like in consist in database found a watch,In statement of CREATE TABLE abortive express without this in the database before carrying out) ,Put in its 's charge so for statement attributive category.Expressing 14-2 is all statement attributive detailed list.
Each parameter meaning explains as follows:ALL
Express to have all statements or object limits of authority.To statement attributive,Only ability of Sysadmin part has all statement limits of authority;To object attributive,Only Sysadmin and ability of Db_owner part have visit some database the attributive of all objects.Statement
State the user has the limits of authority that uses this statement.These statements include:
CREATE DATABASE;CREATE DEFAULT;CREATE PROCEDURE CREATE
RULE CREATE TABLE;CREATE VIEW;BACKUP DATABASE;BACKUP LOG WITH GRANT OPTION
The limits of authority that states this attributive grantor can award a visit data object to other user.? ? ? ? ? ? ? ?
REVOKE and DENY syntactic format and GRANT syntactic pattern are same.
14.4.2 uses limits of authority of government of SQL Server Enterprise Manager
The administration that can achieve pair of statement attributive and object attributive through two kinds of ways in SQL Server,The set that realizes pair of user attributive thereby.These two kinds of ways part to database object to face onefold user knead dough two kinds of attributive are installed.
[1] [2] issues one page