PrepAway - Latest Free Exam Questions & Answers

Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?

Which SQL statement will take the ability to create tables in a table space named MYTBSP
away from user USER1?

PrepAway - Latest Free Exam Questions & Answers

A.
REVOKE CREATETAB ON TABLESPACE mytbsp FROM user1

B.
REVOKE UPDATE OF TABLESPACE mytbsp FROM user1

C.
REVOKE USE OF TABLESPACE mytbsp FROM user1

D.
REVOKE ALTER ON TABLESPACE mytbsp FROM user1

2 Comments on “Which SQL statement will take the ability to create tables in a table space named MYTBSP away from user USER1?”

  2. Chow, Kenneth KY says:

    TABLESPACE database-name.table-space-name,…
    Revokes the privilege to refer to any of the specified table spaces in a CREATE TABLE statement. The default database-name is DSNDB04.
    For table spaces in a work file database you cannot revoke the privilege from PUBLIC. When a table space is created in a work file database, PUBLIC implicitly receives the TABLESPACE privilege (without GRANT authority); this privilege is not recorded in the DB2® catalog, and it cannot be revoked.




    0



    0

Leave a Reply