1 / 2

第二章 SQL 语言

第二章 SQL 语言. 视图 安全保密、查询简单 创建视图语句 : Create view 视图名 () As ... 水平视图和垂直视图 , 行组视图 , 联合视图 视图删除 ( cascade 和 restricted ) 安全性 安全方案基本组成 : 用户、数据库目标和操作权限 用户标记 ( 会话期 ), 标记用户的两种方式 授权语句 : Grant,Revoke(cascade 和 restricted). 第二章 SQL 语言. 系统目录 表、列、用户、视图和特权 SQL 编程 嵌入式 SQL 编程 , 解释与示例说明.

hewitt
Download Presentation

第二章 SQL 语言

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 第二章 SQL语言 • 视图 • 安全保密、查询简单 • 创建视图语句:Create view视图名 () As ... • 水平视图和垂直视图,行组视图,联合视图 • 视图删除(cascade和restricted) • 安全性 • 安全方案基本组成:用户、数据库目标和操作权限 • 用户标记(会话期),标记用户的两种方式 • 授权语句:Grant,Revoke(cascade和restricted) 网络数据库(第六讲)

  2. 第二章 SQL语言 • 系统目录 • 表、列、用户、视图和特权 • SQL编程 • 嵌入式SQL编程,解释与示例说明 网络数据库(第六讲)

More Related