RE: Problem Setting Up User

From: Yadav, Shailesh <NDASY3_at_labor.state.ny.us>
Date: Wed, 02 Jan 2002 14:01:24 -0800
Message-ID: <F001.003E561E.20020102134530@fatcity.com>

Create a synonym for KENNETH.TABLE_NAME coz if she(KIMV) doesn't own it she will have to prefix the owner before the table_name.

HTH
Shailesh

-----Original Message-----
Sent: Wednesday, January 02, 2002 4:05 PM To: Multiple recipients of list ORACLE-L

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Yadav, Shailesh
INET: NDASY3_at_labor.state.ny.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------