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).