QUOTA Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: QUOTA Problem

  1. #1
    Join Date
    Sep 2000
    Posts
    41
    Hi,
    I have a problem here. I have an USER suppose "A". I want to restrict that user from creating any objects in SYSTEM tablespace.

    How do I do this. I have tried

    alter user A quota 0 on SYSTEM;

    alter system set resource_limit = true;

    But still that user is able to create tables in SYSTEM tablespace and populate rows. Please help me out.....


    Thanks

    Amit

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Perhaps the user's default tablespace and temporary tablespace are set to SYSTEM.

    1. Log in as DBA
    2. Determine the default and temporary tablespaces for
    the user from the DBA_USERS view

    3. If set to SYSTEM,

    ALTER USER joe default tablespace USERS;
    ALTER USER joe temporary tablespace TEMP;

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Check your user's system privileges: I'm sure your user has been granted UNLIMITED TABLESPACE privilege, that is why setting his quota on SYSTEM to 0 has had no effect.

    Isue "REVOKE UNLIMITED TABLESPACE FROM A;" and check if he is still able to create objects in SYSTEM tablespace.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

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


Click Here to Expand Forum to Full Width