Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: CREATETAB on tablespace

    How do I grant CREATETAB on selected tablespace and not on entire database?

    Thanks,
    j

  2. #2
    Join Date
    Feb 2002
    Posts
    96
    You can make use of "USE" privilege(tablespace level).

    Regards
    Prakash

  3. #3
    Join Date
    Mar 2003
    Posts
    60
    USE is not allowing users to create tables in that tablespace. Is there any other way to do this. We just want to give them create table access to only one tablespace and not on entire database.

    Thanks,
    j

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Grant CREATETAB on database and then USE OF TABLESPACE only for the tablespace ..

    For eg, if you want user TEST1 to create tables in TEST1_TS, then

    revoke createtab on database from public
    revoke use of tablespace test1_ts from public
    grant createtab on database to user test1
    grant use of tablespace test1_ts to user test1_ts

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

Posting Permissions

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