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

Thread: Why can't new user select other schema?

  1. #1
    Join Date
    Apr 2001
    Johnstown, PA
    I Created user X and granted the roles CONNECT and one that I created from the Ydba account called DEVELOPER.

    The Develolper Role was granted permission to select,insert,update & delete on each table in the Ydba user schema.

    I figured that since I granted the role Developer to user X then he should be able to select on the tables from the Ydba account.

    When I try to :

    select * from Ydba.tab1;

    It says that the table or view does not exist.

    What am I missing? What can I look at to see if I gave the proper permissions for user X to select user Ydba tables through role "Developer"?

    Thank you for your help in advance.

  2. #2
    Join Date
    Mar 2001
    to check that you grant the right priv to role DEVELOPER

    select grantee,owner,table_name,privilege from dba_tab_privs
    where grantee='DEVELOPER';

    then check if role 'DEVELOPER" is granted to X user

    select grantee,granted_role from dba_role_privs
    where granted_role='DEVELOPER';

    also try to create a synonym of the table so that you don't
    need to write the schema every time you want to access
    the tables.

  3. #3
    Join Date
    Apr 2001
    Johnstown, PA


    Thanks for the information.

    I figured out what was happening. I was using Toad to administer the roles. When I assigned the role to X user from my Ydba account, I immediately went over to the X window within my toad session and tried to select on the Ydba tables. What I didn't know was that Toad needs you to disconnect with your session and create a new one for you to see the effect of your changes.

    I'm pretty sure that any DML/DDL command is automatically committed when executed. It appears that Toad does not treat it that way within your current sessions.

    Thanks for taking the time to look at my post.

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