Have you created synonyms? At 01:05 PM 1/2/02 -0800, you 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: Ken Janusz > 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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).
