Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Wed Jan 02 2002 - 16:12:21 CST