View previous topic :: View next topic
|
Author |
Message |
Amit Suri
New User
Joined: 28 Oct 2008 Posts: 25 Location: hyderabad
|
|
|
|
Hi All
While preparing for the DB2-700 Certification i came across this question
I read in the IBM Study material that DBADM CAN NOT create or Drop the
tablespace
Now coming to another popular Db2 Book , it is written that a USER with the CONTROL Privilege On the TABLE-SPACE can Drop it And only the one with SYSADM or DBADM can Grant user the CONTROL Privilege
This tells me that Indirectly a DBADM can Drop the tablespace
The first book is :IBM material for Preparing for DB2-700
Second one is DB2-700 Fundamental Study Guide by Sanders
Could someone please clarify where i am getting it wrong?
Thanks
Amit Suri |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Amit,
Quote: |
DBADM CAN NOT create or Drop the tablespace |
True. If that administrator doesn't have DBADM authority on that database.
Check this link
Is there any reason for writing V8 certification exam(700), when V9 exam(730) for the same is available ?
Thank You,
Sushanth |
|
Back to top |
|
|
Amit Suri
New User
Joined: 28 Oct 2008 Posts: 25 Location: hyderabad
|
|
|
|
Thanks for your response . |
|
Back to top |
|
|
Manshadi
New User
Joined: 31 Aug 2005 Posts: 82
|
|
|
|
Hi,
The following statements is copied from DB2 administrator version 7 on ZOS :
DBADM │ Database administration, which includes DBCTRL over a │
│ │ specific database, plus privileges to access any of its │
│ │ tables through SQL statements. If held with the GRANT │
│ │ option, DBADM can grant those privileges to others. │
│ │ │
│ │ Can also drop and alter any table space, table, or index │
│ │ in the database, issue a COMMENT ON, LABEL ON, or LOCK │
│ │ TABLE statement for any table, and issue a COMMENT ON │
│ │ statement for any index. If the value of field DBADM │
│ │ CREATE VIEW on installation panel DSNTIPP was set to YES │
│ │ during DB2 installation, a user with DBADM authority │
│ │ can: │
│ │ │
│ │ Create a view for another user ID. The view must be │
│ │ based on at least one table and that table must be │
│ │ in the database where the user ID that issued the │
│ │ CREATE VIEW statement has DBADM authority. See the │
│ │ description of the CREATE VIEW statement in Chapter │
│ │ 5 of DB2 SQL Reference. │
│ │ │
│ │ Create an alias for another user ID on any table in │
│ │ the database. │
│ │ │
│ │ However, a user with DBADM authority on one database can │
│ │ create a view on tables and views in that database and │
│ │ other databases if the authorization ID for which the │
│ │ view is created has all other privileges that are │
│ │ required to create the view. A user with DBADM authority │
│ │ cannot create a view on a view that is owned by another │
│ │ user I
I hope it would be help full.
Regards
Manshadi |
|
Back to top |
|
|
|