Re: How can I create a user defined role and assign privileges in

SQLWKS> create role new_role;
Statement processed.
SQLWKS> grant CONNECT, RESOURCE, EXP_FULL_DATABASE, IMP_FULL_DATABASE, CREATE USER, DROP USER to new_role;
Statement processed.

Sorry for giving directly WITH ADMIN OPTION; I do not know...

Franck

|--------+------------------------------->

|        |          ALEMU Abiy           |
|        |          <abiy.alemu_at_criltechn|
|        |          ology.com>           |
|        |                               |
|        |          00-06-09 16:53       |
|        |          Please respond to    |
|        |          ORACLE-L             |
|        |                               |


|--------+------------------------------->

  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>  |
  |       cc:     (bcc: Franck Vasseur/im/esa/ingerrand)                       |
  |       Subject:     How can I create a user defined role and assign         |
  |       privileges in it                                                     |
  >----------------------------------------------------------------------------|

I would like to create a role "NEW_ROLE" and include in this role the following system privileges

        CONNECT, RESOURCE WITH ADMIN OPTON
        EXP_FULL_DATABASE, IMP_FULL_DATABASE
        CREATE USER, DROP USER

Please help ?

--
Author: ALEMU Abiy
  INET: abiy.alemu_at_criltechnology.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).