DB2实验报告9_学号_姓名

•Grant privileges to individuals and groups
•Demonstrate when group privileges are applicable and when individual privileges are required
2.实验设备、软件
PC, windows XPProfessional, DB2 9 Express-c
Show your work belowby printing screen.
12.As db2admin, try creating your test table again. Issue the following SQL statement to create your test table.
db2 "create table test1 (partnointeger, subpart integer) in DMS04"
Did the statement complete successfully? What does this imply?
11.As db2admin, you ask your good friend, the corporate spy, who happens to have DBADM privilege, to grant you USE privilege on DMS04.
Show your work belowby printing screen.
2.What tasks can anyone that has an ID that has been authenticated successfully do against the MUSICDB database?
二、实验过程（实验步骤、记录、数据、分析）
Section 1 - Default PUBLIC Privileges
1. From the DB2 Control Center, determine the current database authorization that all users possess against the database by default.
At the end of the lab, students should be able to:
•Describe the default privileges available to PUBLIC
•Administer DB2 authorities (SYSADM, SYSCTRL, SYSMAINT, and DBADM) and describe the functional capabilities of each authority
18.Certainly, you do not want your production system exposed to object creation from users creating test objects. List the steps you should take in order to begin securing the production environment.
Show your work belowby printing screen.
15.What do you discover? When you originally estimated the size requirements for DMS04, did you anticipate this?
Show your work belowby printing screen.
9.Did the SQL statement complete successfully? Why or why not?
10.As db2admin, you decide that the DMS04 table space looks as good as any to contain your test table. Issue the following SQL statement to create your test table.
db2 "create table test1 (partnointeger, subpart integer) in DMS04"
Show your work belowby printing screen.
21.Is the user able to create a table?
22.Is db2admin still connected to the database? Does this mean the revoke of the CONNECT authority was not completed?
db2 "create table test1 (partnointeger, subpart integer) in DMS04"
Did the SQL statement complete successfully? What does this imply?
Show your work belowby printing screenand answer the question.Hale Waihona Puke 吉林大学DB2实验报告
班级：
姓名：
学号：
姓名
学号
实验项目
9.Security
实验性质
□演示性实验□验证性实验
操作性实验□综合性实验
实验地点
机器编号
指导教师
实验时间
年 月 日 时 分
一、实验综述
1.实验目的及要求
This lab contains several sections. You should attempt to complete the first three sections as time permits, in sequence. Section 4 is considered optional if this is the last lab of the class. However, if this lab is not being done as the last lab, then you should complete Section 4 regardless of the number of other sections completed in order to reset your lab environment.
Issue the following SQL statements to determine the table spaces that have been defined on the system.
db2 "selectsubstr(tbspace,1,18) fromsyscat.tablespaces”
16.As student, drop the table DB2ADMIN.TEST1 to remove it from the database.
Show your work belowby printing screen.
17.Why were you able to drop a table in a schema different than your own?
Show your work belowby printing screen.
8.Recall that you created several table spaces during a prior lab and you determined and placed specific tables in those table spaces as part of your design. Assume that you are db2admin and you have just connected. You now want to create a test table in order to play with some SQL recursive query syntax that you have just learned.
4.The LOAD column contains an international not sign. Who can load data?
5.Can you tell that this grant is done automatically by the database manager during some process? How could you find out this information?
19.Revoke the default database privileges that have been granted to PUBLIC.
Show your work belowby printing screen.
20.From your db2admin session, attempt to submit the CREATE TABLE statement again.
23.Assume you had a business reason to revoke connect from a user and then ensure that any connections established by the user were disconnected. You have alreadycompleted the revoke. Document and complete the remaining steps required. (Consult the solutions if you are not sure of your process.)