《工业园区管理中心管理手册》.pdf
《《工业园区管理中心管理手册》.pdf》由会员分享,可在线阅读,更多相关《《工业园区管理中心管理手册》.pdf(95页珍藏版)》请在文库网上搜索。
1、long River? There are some villages around there. We can also enjoy delicious food in the town. Zhu Hui :It s a good idea. See you this weekend. 三、短文填空。从下面方框中选出10 个单词,用它们的适当形式填入短文后的空格内,使 短文意思正确、通顺(每词限用一次)。(共10 小题,每小题1 分;计 10 分) Last summer vacation, I went to Hawaii ( 夏威夷 ) with my family. We had a
2、nice time _1_ there. we stayed at a hotel on the beach. And the hotel had a clean and big swimming pool. The beach was so beautiful that many _2_ went there. Some _3_ in the water, some went fishing, _4_ played beach volleyball. As _5_, the weather was sunny and hot, so we went swimming. There were
3、around two _6_ people in the pool, so we had to drink coffee by the pool. I like sports very much, so I did morning _7_ before breakfast. For dinner, we walked to the center of the city to try their specials. One day, we went to the mountains. The bus trip there was _8_. We saw many beautiful views
4、along the way. It _9_ us half an hour to get there. The mountains were very beautiful. The next day we went shopping for clothes. Hawaii shirts were very nice. The people were_10_ to us, too. 四、阅读表达。(共10 小题,计分10 分) A.补全短文。根据短文内容,从短文后的AF 选项中选出适当的选项补全短文,并将选 项的编号字母填写在答题卡相应题号后(有一个选项多余)。(共 5 小题,每小题1 分;计
5、5 分) A few years ago, my husband( 丈夫) and I were on a vacation. _1_when we thought about what to do first. “ We want to go to the b utterfly museum, ” said Ariela and Eliana. _2_ when we walked into the museum. My girls were jumping up and down for them, I knew it was right for us to visit the museu
6、m. They were having so much fun. I turned to our museum tour guide ( 导游 ) because I wanted to ask some questions. “ How exercise for friend hundred interest leave other relax swim take usually visit long do butterflies live? ”She said, “ About ten days. ” “ What can butterflies do in ten days? ” I a
7、sked. The guide stopped, looked at me and said, “ _3_” . “ Wow, ” I said, “I never thought about butterflies like that. Thank you. ” After we said goodbye, I couldn t stop thinking about what the guide had said. She was right. _4_. We can make a difference. Thanks for your influence (影响 ) on your fa
8、mily, friends, co - workers and neighbors. _5_ like a butterfly. A. We saw thousands of beautiful butterflies. B. They make the world a more beautiful place. C. We all have something to give to the world. D. Our girls jumped in and told us exactly what they wanted to do. E. You have your own way of
9、making the world better for everyone. F. We enjoyed our time visiting the butterfly museum. B. 完成表格。阅读下面短文,完成题后的表格。(共5 小题,每小题1 分; 计 5 分) Your schooldays should be good and happy days of your life. How can they be useful to you? You can do these things. Be active (积极的 ) at school. Don t always say th
10、ings are difficult or boring to your school life and your school subjects. Join lots of activities. Put up your hands qu俸俸E创建角色 (通常由 DBA 完成) ALTER USER修改用户密码 REVOKE收回权限 通过本章学习,您已经可以使用 DCL 控制数据库权限, 创建数据库联接: 13-22Copyright Oracle Corporation, 2001. All rights reserved. 13-23Copyright Oracle Corporatio
11、n, 2001. All rights reserved. 13-24Copyright Oracle Corporation, 2001. All rights reserved. 13-25Copyright Oracle Corporation, 2001. All rights reserved. $踹Hc00耀?耀!瀀瀀琀0pp耀0儀卬耀0氀璻耀013 Copyright Oracle Corporation, 2001. All rights reserved. 控制用户权限 13-2Copyright Oracle Corporation, 2001. All rights re
12、served. 目标 通过本章学习,您将可以: 创建用户 创建角色 使用GRANT 和 REVOKE 语句赋予和回收权限 创建数据库联接 13-3Copyright Oracle Corporation, 2001. All rights reserved. 控制用户权限 数据库管理员 用户 用户名和密码 权限 13-4Copyright Oracle Corporation, 2001. All rights reserved. 权限 数据库安全性: 系统安全性 数据安全性 系统权限: 对于数据库的权限 对象权限: 操作数据库对象的权限 方案: 一组数据库对象集合, 例如表, 视图,和序列
13、13-5Copyright Oracle Corporation, 2001. All rights reserved. 系统权限 超过一百多种 100 有效的权限 数据库管理员具有高级权限以完成管理任务,例如: 创建新用户 删除用户 删除表 备份表 13-6Copyright Oracle Corporation, 2001. All rights reserved. 创建用户 DBA 使用 CREATE USER 语句创建用户 CREATE USER scott IDENTIFIED BY tiger; User created.User created. CREATE USER user
14、 IDENTIFIED BY password; 13-7Copyright Oracle Corporation, 2001. All rights reserved. 用户的系统权限 用户创建之后, DBA 会赋予用户一些系统权限 以应用程序开发者为例, 一般具有下列系统权限: CREATE SESSION(创建会话) CREATE TABLE(创建表) CREATE SEQUENCE(创建序列) CREATE VIEW(创建视图) CREATE PROCEDURE(创建过程) GRANT privilege , privilege. TO user , user| role, PUBLI
15、C.; 13-8Copyright Oracle Corporation, 2001. All rights reserved. 赋予系统权限 DBA 可以赋予用户特定的权限 GRANT create session, create table, create sequence, create view TO scott; Grant succeeded.Grant succeeded. 13-9Copyright Oracle Corporation, 2001. All rights reserved. 角色 不使用角色分配权限使用角色分配权限 权限 用户 Manager 13-10Cop
16、yright Oracle Corporation, 2001. All rights reserved. 创建角色并赋予权限 CREATE ROLE manager; Role created.Role created. GRANT create table, create view TO manager; Grant succeeded.Grant succeeded. GRANT manager TO DEHAAN, KOCHHAR; Grant succeeded.Grant succeeded. 创建角色 为角色赋予权限 将角色赋予用户 13-11Copyright Oracle C
17、orporation, 2001. All rights reserved. 修改密码 DBA 可以创建用户和修改密码 用户本人可以使用ALTER USER 语句修改密码 ALTER USER scott IDENTIFIED BY lion; User altered.User altered. 13-12Copyright Oracle Corporation, 2001. All rights reserved. 对象权限 表 视图 序列 过程 修改 删除 执行 索引 插入 关联 选择 更新 对象权限 13-13Copyright Oracle Corporation, 2001. Al
18、l rights reserved. 对象权限 不同的对象具有不同的对象权限 对象的拥有者拥有所有权限 对象的拥有者可以向外分配权限 GRANTobject_priv (columns) ONobject TOuser|role|PUBLIC WITH GRANT OPTION; 13-14Copyright Oracle Corporation, 2001. All rights reserved. 分配对象权限 分配表 EMPLOYEES 的查询权限 分配表中各个列的更新权限 GRANT select ON employees TO sue, rich; Grant succeeded.G
19、rant succeeded. GRANT update (department_name, location_id) ON departments TO scott, manager Grant succeeded.Grant succeeded. 13-15Copyright Oracle Corporation, 2001. All rights reserved. WITH GRANT OPTION 和 PUBLIC 关键字 WITH GRANT OPTION 使用户同样具有分配权限的权利 向数据库中所有用户分配权限 GRANT select, insert ON department
20、s TO scott WITH GRANT OPTION; Grant succeeded.Grant succeeded. GRANT select ON alice.departments TO PUBLIC; Grant succeeded.Grant succeeded. 13-16Copyright Oracle Corporation, 2001. All rights reserved. 查询权限分配情况 数据字典视图描述 ROLE_SYS_PRIVS角色拥有的系统权限 ROLE_TAB_PRIVS角色拥有的对象权限 USER_ROLE_PRIVS用户拥有的角色 USER_TAB
21、_PRIVS_MADE用户分配的关于表对象权限 USER_TAB_PRIVS_RECD用户拥有的关于表对象权限 USER_COL_PRIVS_MADE用户分配的关于列的对象权限 USER_COL_PRIVS_RECD用户拥有的关于列的对象权限 USER_SYS_PRIVS用户拥有的系统权限 13-17Copyright Oracle Corporation, 2001. All rights reserved. 收回对象权限 使用 REVOKE 语句收回权限 使用 WITH GRANT OPTION 子句所分配的权限同样被 收回 REVOKE privilege , privilege.|AL
22、L ON object FROM user, user.|role|PUBLIC CASCADE CONSTRAINTS; 13-18Copyright Oracle Corporation, 2001. All rights reserved. 收回对象权限举例 REVOKE select, insert ON departments FROM scott; Revoke succeeded.Revoke succeeded. 13-19Copyright Oracle Corporation, 2001. All rights reserved. 数据库联接 数据库联接使用户可以在本地访问
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 工业园区管理中心管理手册 工业园区 管理中心 管理 手册