Tablespace privilege?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Tablespace privilege?

  1. #1
    Join Date
    Nov 2000
    Posts
    160

    Angry

    Hi all,

    I created a user with default (TESTTBSP) and temp tablespaces and granted it with roles. However, when I created a table, I got an error, "ORA-01950: no privileges on tablespace 'TESTTBSP'กจ. I thought the privilege to the tablespace is set when the user is created with default tablespace. Can you give me advice for what should be done please?

    Thanks,
    Tina

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You have to give them a quota on the tablespace. For example:
    Code:
    alter user xyz quota unlimited on TESTTBSP'
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking


    check DBA_TS_QUOTAS view to determine if you have any quota on that tablespace for that user. If the user has no quota, then they will not be able to create objects there.

    grant a quota to the user if this is the case. Although they might have a default tablespace, they might not have a quota on it.

    - Magnus

  4. #4
    Join Date
    Nov 2000
    Posts
    160
    Thank you all. It is the quota issue, and I have it set. Now I have no problem creating tables. Thanks a lot!

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