#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Location
    Orlando FL
    Posts
    130
    Rep Power
    13

    assigning tablespaces to user


    Hi all,

    Is it possible to assign multiple tablespaces to a singe user beside the default one? What commands do I use to do that in sqlplus?

    Thanks
    Help me, help you, help others...
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
    Tablespaces or schemas?
    Do you want him to be able to select on tables belonging to other schemas?
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Location
    Orlando FL
    Posts
    130
    Rep Power
    13
    just table space.

    For example, if I create new user I get to pick a default tablespace, USER. Now how can I also add the EXAMPLE tablespace to the new user so he/she can see the tables under EXAMPLE tablespaces as well?
    Help me, help you, help others...
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2002
    Posts
    693
    Rep Power
    26
    Originally posted by digitsnake
    just table space.

    For example, if I create new user I get to pick a default tablespace, USER. Now how can I also add the EXAMPLE tablespace to the new user so he/she can see the tables under EXAMPLE tablespaces as well?
    think of tablespaces as disk partitions which you have access to create tables in, which can be limited by quotas:

    ie. alter user my_user quota unlimited on tablespace ts_?;

    Providing quotas on tablespaces has nothing to do with getting access to the tables of another user, the user that owns the table has to grant you privs on the tables:

    ie. grant select on my_table to bob;

    the default tablespace when you create a user is the ts where your tables will be create if you don't specify when you do a create table command.
  8. #5
  9. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    539
  10. #6
  11. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2002
    Location
    Orlando FL
    Posts
    130
    Rep Power
    13
    "grant select on my_table to bob;" is what I am looking for!

    Thanks hedge and pabloj. You two are very kind.
    Help me, help you, help others...

IMN logo majestic logo threadwatch logo seochat tools logo