Ken, First a question - what did you do for Oracle when you worked there?
second... KIMV needs a synonym for the table to be able to refer to it with an owner qualifier third, you can only have ONE default role. Think about it. If you really want the user to have the privs of several roles at once, create another role, a "superrole" that is granted both DB and RESOURCE and the grant that one as default. And you really do have to RTFM Rachel --- Ken Janusz <[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: 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). __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
