Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Location
    Mumbai, India
    Posts
    26

    Question Unanswered: Revoke UNLIMITED TABLESPACE privilege

    I have assigned CONNECT and RESOURCE roles to a user in a database.

    Now I want to revoke UNLIMITED TABLESPACE system privilege from user.

    How do I revoke this privilege without creating any problems?
    That user has tables in multiple tablespaces and also indexes in multiple tablespaces. If I revokes a privilege then I think further growth of tables will stop.
    If I revoke a privilege and give quota to tablespaces where my tables are present then do i need to give quota on tablespace where indexes are present?
    *********************************************
    God Bless You.

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Yes, if you remove the unlimited quota privilege, you must grant table space quota on EVERY table space that has any type of objects from the user. if you want them to grow. They will not remove existing objects, but nothing new or larger without a quota
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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