ISO-9075-1-2003.pdf
《ISO-9075-1-2003.pdf》由会员分享,可在线阅读,更多相关《ISO-9075-1-2003.pdf(93页珍藏版)》请在三一文库上搜索。
1、 ICS 35.060 Ref. No. ISO/IEC 9075-1:2003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved Published in Switzerland INTERNATIONAL STANDARD ISO/IEC 9075-1:2003 TECHNICAL CORRIGENDUM 1 Published 2005-11-15 INTERNATIONAL ORGANIZATION FOR STANDARDIZATION ORGANISATION INTERNATIONALE DE NORMALISATION INTERNA
2、TIONAL ELECTROTECHNICAL COMMISSION COMMISSION LECTROTECHNIQUE INTERNATIONALE Information technology Database languages SQL Part 1: Framework (SQL/Framework) TECHNICAL CORRIGENDUM 1 Technologies de linformation Langages de base de donnes SQL Partie 1: Charpente (SQL/charpente) RECTIFICATIF TECHNIQUE
3、1 Technical Corrigendum 1 to ISO/IEC 9075-1:2003 was prepared by Joint Technical Committee ISO/IEC JTC 1, Information technology, Subcommittee SC 32, Data management and interchange. Statement of purpose for rationale A statement indicating the rationale for each change to ISO/IEC 9075-1:2003 is inc
4、luded. This is to inform the users of ISO/IEC 9075-1:2003 why it was judged necessary to change the original wording. In many cases, the reason is editorial or to clarify the wording; in some cases, it is to correct an error or an omission in the original wording. Notes on numbering Where this Techn
5、ical Corrigendum introduces new Syntax, Access, General, and Conformance Rules, the new rules have been numbered as follows: Rules inserted between, for example, Rules 7) and 8) are numbered 7.1), 7.2), etc. or 7)a.1), 7)a.2), etc. Those inserted before Rule 1) are numbered 0.1), 0.2, etc. Where thi
6、s Technical Corrigendum introduces new subclauses, the new subclauses have been numbered as follows: Subclauses inserted between, for example, 4.3.2 and 4.3.3 are numbered 4.3.2a, 4.3.2b, etc. Those inserted before, for example, 4.3.1 are numbered 4.3.0, 4.3.0a, etc. Copyright International Organiza
7、tion for Standardization Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/04/2007 01:15:48 MDTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-1:2003/Cor.1:2005(E) ii ISO/IEC 2005 All rights reserved Cop
8、yright International Organization for Standardization Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/04/2007 01:15:48 MDTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-1:2003/Cor.1:2005(E) ISO/IEC 20
9、05 All rights reserved iii ContentsPage Foreword. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 3Definitions and use of terms . . . . . . . . . . . . . . . . . . . . . . . .
10、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 3.1.1Definitions provided in this standard . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4Concepts. . . . . . . . . . . . . . . . . . . . . . . . . .
11、. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4.2SQL-environments and their components. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4.2.5aRoles. . . . . . . . . . . . . . .
12、 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 4.6SQL-schema objects. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
13、4.6.13Roles. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 6Notation and conventions used in other parts of ISO/IEC 9075 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
14、 2 6.3Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 6.3.3Use of terms. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
15、. . . . . . . . . . . . . . . . . . . . 2 6.3.3.8General Rules not terminated on exception conditions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 6.3.5Relationships of parts within ISO/IEC 9075. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
16、 . . . . . . . . . . . . . . . . . . 3 6.3.5.1New and modified Clauses, Subclauses, and Annexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 6.3.5.5New and modified tables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
17、. . . . . . . . . . . . . . . . . . . . . 4 6.3.5aSubclauses used as subroutines. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Copyright International Organization for Standardization Provided by IHS under license with ISO Li
18、censee=IHS Employees/1111111001, User=Wing, Bernie Not for Resale, 04/04/2007 01:15:48 MDTNo reproduction or networking permitted without license from IHS -,-,- Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=IHS Employees/1111111001, User=Win
19、g, Bernie Not for Resale, 04/04/2007 01:15:48 MDTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-1:2003/Cor.1:2005(E) ISO/IEC 2005 All rights reserved 1 Information technology Database languages SQL Part 1: Framework (SQL/Framework) TECHNICAL CORRIGENDUM 1 Forewor
20、d 1.Rationale:Remove incorrect reference to obsolete part. In the 7th paragraph, delete the 5th bullet. 3Definitions and use of terms 3.1.1 Definitions provided in this standard 1.Rationale:Delete an erroneous definition. Delete definition 3.1.1.18 4Concepts 4.2SQL-environments and their components
21、4.2.5a Roles 1.Rationale:A role is not a schema object, nor is it a collection of role authorizations therefore the description of roles is moved from subclause 4.6.13 to subclause 4.2.5a. Copyright International Organization for Standardization Provided by IHS under license with ISO Licensee=IHS Em
22、ployees/1111111001, User=Wing, Bernie Not for Resale, 04/04/2007 01:15:48 MDTNo reproduction or networking permitted without license from IHS -,-,- ISO/IEC 9075-1:2003/Cor.1:2005(E) 2 ISO/IEC 2005 All rights reserved 4.2.5aRoles A role is a potential grantee and grantor of privileges and other roles
23、. A role can also own schemas and other objects. A role authorization permits a grantee (see Subclause 4.6.12, “Privileges”) to use every privilege granted to the role. It also indicates whether the role authorization is grantable, in which case the grantee is authorized to grant the role, to revoke
24、 a grant of the role, and to destroy the role. 4.6SQL-schema objects 4.6.13 Roles 1.Rationale:A role is not a schema object, nor is it a collection of role authorizations; therefore the description of roles is moved from subclause 4.6.13 to subclause 4.2.5a. Delete the entire Subclause. 6Notation an
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- ISO 9075 2003
链接地址:https://www.31doc.com/p-3779428.html