Hi Ken, You have to fully specify all of the roles that you want to be default in one alter statement
alter user kimv default role connect,db,resource; should turn all to YES. You may also need to make sure that your synonyms are public. Hope this helps, John [EMAIL PROTECTED] wrote: >I am having a problem setting up a user on my DB (W2000 / 8.1.7). > >I have my self as user KENNETH and the new user is KIMV. > >She can access tables via KENNETH.TABLE_NAME or SYS.TABLE_NAME but not jus >TABLE_NAME. > >Here is what I have (I am grantee KENNETH and the user I am setting up is >KIMV): > >GRANTEE GRANTED_ROLE DEFAULT_ROLE >KENNETH CONNECT YES >KENNETH DBA YES >KENNETH EXP_FULL_DATABASE YES >KENNETH IMP_FULL_DATABASE YES >KENNETH RESOURCE YES >KENNETH SELECT_CATALOG_ROLE YES >KIMV CONNECT NO >KIMV DB NO >KIMV KIMVO NO >KIMV RESOURCE YES >KIMVO CONNECT YES >KIMVO RESOURCE YES > >Also, Oracle will only allow me to have one granted role as YES at a time. >For example if I set DB to YES then RESOURCE goes to NO. > >Your help will be greatly appreciated. > >Thanks, >Ken > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).