Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    96

    Question Unanswered: Revoke tablespace privileges.

    How can i revoke tablespace privileges(from a userid) in DB2 V6.1? Because V6 does not support this. Since this is production system, i can not drop and recreate tablespaces. Is there any way to do it??

  2. #2
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96

    Re: Revoke tablespace privileges.

    Originally posted by cgprakash
    How can i revoke tablespace privileges(from a userid) in DB2 V6.1? Because V6 does not support this. Since this is production system, i can not drop and recreate tablespaces. Is there any way to do it??

    Prakash,


    In DB2 UDB V6.x , tablespace privileges can not granted.

    but in V7

    following command can be used to control tablespace privileges


    REVOKE USE OF TABLESPACE tablespace-name FROM USER


    Let me know , if any questions


    Thank You

    Lekharaju Ennam

  3. #3
    Join Date
    Feb 2002
    Posts
    96
    Thanks.

    Yes. We can not grant tablespace privileges seperately(in V6).
    But when we create a database, tablespace(userspace1) USE privilege will be granted to PUBLIC(by default). How can we revoke this??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •