Re: Problem Setting Up User

Hi Ken,

You have to fully specify all of the roles that you want to be default in one alter statement

alter user kimv default role connect,db,resource;

should turn all to YES.

You may also need to make sure that your synonyms are public.

Hope this helps,
John

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: orantdba
  INET: orantdba_at_netscape.net

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