RE: What privileges/roles are rquired to create a user

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <JDunn@xxxxxxxxx>, "oracle-l digest users" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Sep 2010 08:30:08 -0400

The easiest way is to create the user as system connected normally.
Assuming you don't want to do that you then need an account in the
database with the dba role or the create user and grant any role system

Dick Goulet 
Senior Oracle DBA/NA Team Lead 
PAREXEL International 



From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Dunn
Sent: Thursday, September 16, 2010 3:48 AM
To: oracle-l digest users
Subject: What privileges/roles are rquired to create a user

Currently whenever we create a new user and grant that user privileges
we do that as SYSDBA
We would prefer not to do this as SYSDBA
But what are the minimum privilege(s)/role(s) that a user needs to allow
that user to create new users and grant them privileges? 




Other related posts: