User cannot see tables created by another user
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: User cannot see tables created by another user

  1. #1
    Join Date
    Feb 2002
    Posts
    14

    User cannot see tables created by another user

    Hi there, I am trying to setup a db with 2 user types.

    appadmin
    appuser

    appadmin is used for creating stuff whilst
    appuser just for queries and updates.

    I created the users and I created 2 associated
    roles. However I have not setup the appuser role yet.

    i created a load of tables connected as
    appadmin user into the app tablespace.

    Both users have default tablespace app.

    Why is it that i can only see these tables
    connected as appadmin and not appuser??

    Pointers appreciated.

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Re: User cannot see tables created by another user

    Originally posted by adcworks
    Why is it that i can only see these tables
    connected as appadmin and not appuser??
    Privileges... Your appuser need privileges to access tables created by appadmin. Either grant privileges directly to appuser or grant through role.. and grant that role to appuser..

    Sameer

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    where are synonyms?

    where are the grants on those tables to appuser?

  4. #4
    Join Date
    Feb 2002
    Posts
    14
    yes but which privileges do I need to create?

  5. #5
    Join Date
    Feb 2002
    Posts
    14

    still no joy

    connected in as appadmin i tried

    grant all privileges on table1 to appuser_role;

    grant appuser_role to appuser;

    connecting as appuser still shows no table

  6. #6
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Re: still no joy

    Originally posted by adcworks
    connected in as appadmin i tried

    grant all privileges on table1 to appuser_role;

    grant appuser_role to appuser;

    connecting as appuser still shows no table
    what you mean "connecting as appuser still shows no table"

    While quering table1 you must qualify that table

    connect as appuser and then

    Code:
    select * from appadmin.table1
    or else create private synonym for table1 to avoid qualification..

    connect as appuser
    Code:
    create synonym table1 for appadmin.table1;
    then only you will able to select without qualifing

    Sameer
    Last edited by Sameer; 10-28-2002 at 11:53 AM.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    I thought I mentioned synonyms as well

  8. #8
    Join Date
    Feb 2002
    Posts
    14
    that's quite a long winded way of exposing tables created by ne user to other users is it not? Is this the only way

    ps: yes it worked. thanks

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