User
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: User

  1. #1
    Join Date
    Jul 2000
    Posts
    147

    User

    I have a user X with default tablespce TEST. Tablespace TEST has 10 tables. When I connect through sql as user X , I can see all the tables.

    When I created a user T2 with default tablespace TEST Iím not able to see any of the table. Am I missing something?

    Thanks!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Two things:
    1. user T2 doesn't have permission on X's tables.
    2. user T2 has to reference the tables as X.tablename.
    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
    Jul 2000
    Posts
    147
    Thanks Jeff,

    Could you please tell me how do I do that or point me to a doc?

    Many thanks!

  4. #4
    Join Date
    Aug 2005
    Location
    Nigeria
    Posts
    14
    user T2 has to be granted privileges on X's tables before user T2 can have access to the tables
    The purpose of life is a life of purpose.

  5. #5
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    Quote Originally Posted by dba_dada
    Thanks Jeff,

    Could you please tell me how do I do that or point me to a doc?

    Many thanks!
    1. Connect as the user(let us say X) who is the owner of tables.

    2. Give other user(let us say Y) the appropriate privileges(let us say
    select) on the tables(let us say a1,a2) as.
    sql> Grant select on a1,a2 to Y

    3. Connect as other user(Y).

    4. sql> select * from X.a1
    sql> select * from X.a2

  6. #6
    Join Date
    Sep 2005
    Posts
    4
    as user system

    create synonym t2.table for x.table;
    grant all on x.table to t2.table;

    that way you dont need to use the x before the tablename during select or describe

    do that for all tables and your setl

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