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 <ken.janusz_at_sufsys.com> 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: ken.janusz_at_sufsys.com
>
> 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: ListGuru_at_fatcity.com (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: wisernet100_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Wed Jan 02 2002 - 20:21:30 CST
